My DataStage installation seems to have problem dealing with Timestamp datatype with DB2.
I have a simple testing job with a DB2 Enterprise Stage selecting a single timestamp column, and output to a sequential file. The job failed during execution with error "main_program: Fatal Error: Invalid Format".
In Designer, when using "View Data" function directly at the DB2 Enterprise Stage, data is returned properly on the view data window.
We have already tried playing around with the format string / microsecond extension...etc but ended up with the same error.
Appreciate any suggestion to tackle this problem.
Thanks.
DB2 Timestamp Problem
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Are you using the default timestamp format? If not, is the format you have specified valid (for example, does each component have a leading "%" character)? Are you returning fractional seconds from DB2, which your format does not recognize?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.