Hallo
I work in DB2 for OS/390 (a big mainframe:-)
We have 3 DB: Test, Integration and Production.
*Only* in Integration I have the following problem when I read a Column type TIMESTAMP:
in the DB2 catalog the column is so defined:
COLTYPE: TIMESTMP
LENGTH: 10
SCALE: 6
but when I read the table I obtain in the MetaData tab in Squirrel):
getColumnTypeName: TIMESTAMP ok
getPrecision: 26 ok
getScale: 6 ok
getColumnClassName: java.lang.String --- not ok!
A Timestamp colum is so read: 2013-10-18 23:27 instead of 2013-10-04-09:04:08.064741.
This is so for ALL columns type TIMESTAMP, but only in Integration!
When I read the SAME table in Test, the getColumnClassName is right: java.sql.Timestamp
The definitions are the same in Test and in Integration.
What can I do?
Thank you for any help
er
|