9 digit precision in timestamp in datafiles

udayanguha · Post by **udayanguha** » Mon Oct 05, 2015 10:56 pm

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?

chulett · Post by **chulett** » Tue Oct 06, 2015 7:25 am

Seems to me you'd need to stick with DB2 utilities for this.

qt_ky · Post by **qt_ky** » Tue Oct 06, 2015 7:57 am

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.

chulett · Post by **chulett** » Tue Oct 06, 2015 9:37 am

That very thought occurred to me while I was driving into work this morning... figured someone else would probably beat me to it.