I have some data files in which the timestamp is like yyyy-mm-dd hh:mm:ss.000000000
So after the seconds field, there are 9 digits (I think it denotes nano seconds). I need to load this data into Db2 but don't think Datastage handles anything more than microseconds.
How can I load such data into Db2?
9 digit precision in timestamp in datafiles
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 37
- Joined: Wed Oct 29, 2014 10:48 pm
- Location: Ohio
It looks like DataStage supports up to 6 digits for fractional seconds whereas DB2 and ODBC support up to 12 digits. Strange that it doesn't match up...
You may be able to handle it as a string data type (char or varchar) in DataStage and cast it to DB2 TIMESTAMP data type when you load it.
You may be able to handle it as a string data type (char or varchar) in DataStage and cast it to DB2 TIMESTAMP data type when you load it.
Choose a job you love, and you will never have to work a day in your life. - Confucius