Unable to read Timestamp(6) in Oracle Stage

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
rajikatam
Participant
Posts: 4
Joined: Thu Nov 16, 2006 2:43 am
Location: banglore

Unable to read Timestamp(6) in Oracle Stage

Post by rajikatam »

Hi,

My source and target are Oracle stages. I am getting data into source column timestamp with milli seconds. Eg:- 01/12/2012 12:10:06.969696 AM

When i am reading this from the oracle stage i am getting error in oracle stage as

> Traceback: Could not obtain stack trace; check that 'gdb' and 'sed' are installed and on your PATH.

How to load this source timestamp milli seconds column to timestamp target column.

Can you please help me on this.

Thanks in Advance.
RAJIREDDY
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Your DataStage timestamp column must also have the Extended attribute of "milliseconds" in order for those values to be passed through or used in DataStage.
Post Reply