Setting microsecond portion of Timestamp???

Salegueule · Post by **Salegueule** » Thu Jan 22, 2009 3:24 pm

Hi,

I am working on converting some ETL programs from COBOL MVS to Unix DataStage PX. On some condition, one of the COBOL program is setting a timestamp column to '9999-12-31 23:59:59.999999'.

Although DataStage does not seems to kick or issue warning of any sorts, I am getting '9999-12-31 23:59:59.000000' as a results, loosing my 9's. I have try a couple of thing but looks like DataStage does not handle the microsecond portion when it comes to set it. It does that right though if I am only passing the value from the source though.

Does anyone can help getting my.999999 ?

Thanks.

kandyshandy · Post by **kandyshandy** » Thu Jan 22, 2009 3:38 pm

Did you try concatenating timestamp part with hardcoded '.999999' and loading them to target field?

ray.wurlod · Post by **ray.wurlod** » Thu Jan 22, 2009 3:47 pm

What is the format picture you are using for the timestamp? Does it include the fractional seconds part?

Salegueule · Post by **Salegueule** » Thu Jan 22, 2009 4:17 pm

kandyshandy wrote:Did you try concatenating timestamp part with hardcoded '.999999' and loading them to target field?

Hi,

Yes I have tried that and not working for me.

Salegueule · Post by **Salegueule** » Thu Jan 22, 2009 4:20 pm

ray.wurlod wrote:What is the format picture you are using for the timestamp? Does it include the fractional seconds part? ...

Hi,

I am using the following:

CONSENT_END_TIMEST: timestamp[microseconds] {text, timestamp_format="%yyyy-%mm-%dd-%hh.%nn.%ss.6"}

Thanks!