Search found 4 matches
- Tue Feb 26, 2008 10:12 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ODBC stage returns incorrect microseconds value in timestamp
- Replies: 10
- Views: 4125
I am using the following ODBC driver: IBM DB2 ODBC Driver version 8.01.09.917 I have created a server job and used the ODBC stage to view the DB2 table and the microsecond data is returned successfully. This would indicate to me that the ODBC driver is capable of handling the timestamp. Using a para...
- Tue Feb 26, 2008 9:51 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ODBC stage returns incorrect microseconds value in timestamp
- Replies: 10
- Views: 4125
I have also found that the problem occurs when I use the ODBC Enterprise stage as a sparse lookup with the lookup stage. The timestamp value I retrieve from the lookup to the DB2 table has .000000 at the end. Basically, anytime I use the ODBC Enterprise stage the microseconds data is lost, it doesn'...
- Tue Feb 26, 2008 4:17 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ODBC stage returns incorrect microseconds value in timestamp
- Replies: 10
- Views: 4125
- Mon Feb 25, 2008 5:27 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ODBC stage returns incorrect microseconds value in timestamp
- Replies: 10
- Views: 4125
ODBC stage returns incorrect microseconds value in timestamp
Hi, I am having an issue with the ODBC Enterprise stage while reading data from a DB2 table. The table contains timestamps with the following format: %yyyy-%mm-%dd %hh:%nn:%ss.6 e.g. 2003-12-01 12:34:56.123456 When I do a view data the timestamps all end with .000000 which is not what is contained i...