By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,610 Members | 1,697 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,610 IT Pros & Developers. It's quick & easy.

Date formatting with DB2 type 4 JDBC Driver

P: 1
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
Nov 20 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.