DSXchange

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.

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

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

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.

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!