In my company we are runing java Webshere applications on Windows platform and connecting to DB2 V8 on z/OS mainframe. Until now we have used the type 2 JDBC driver, which are using the DB2 Connect software to obtain connection.
Right now we are planning to move to type 4 JDBC driver, which supports direct connection to DB2 V8 on z/OS using native TCP/IP. That is, we don't need the DB2 Connect overhead anymore.
But we seem to have a problem with date formatting (EUR, ISO or LOCAL), as our applications need to present dates in different formats. By using the DB2 Connect software (type 2) the date format can be defined as a property on each predefined and cataloged database connection and thus deliver dates in desired format.
But by using Type 4 driver and pure TCP/IP we don't have this option. I guess we have to append the desired date format as a property to the connection string along with user credentials etc., but I haven't been able to find any documentation so far in any IBM books.
Can somebody help, please.
Thanks, Hylle