Timestamp Column issue in bulk load

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
dbdecoy
Premium Member
Premium Member
Posts: 17
Joined: Tue Jul 15, 2008 1:17 pm
Location: Hyderabad

Timestamp Column issue in bulk load

Post by dbdecoy »

Team, I am doing bulk load on oracle. It has time stamp column. In DB NLS_TIMESTAMP_FORMAT ser as 'dd-MMM-YY HH:MI:SS'. Datastage I tried to change default time stamp format as 'dd-MMM-yy HH:MI:SS'. when I write to Dataset and see it is still in 'dd-mm-yyyy hh:mm:ss' format .

Because of it, Bulk load fails stating ORA-01821 date format not recognized. Please advice how can we change time stamp to DB format in Datastage.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Store it as a string in that format.
-craig

"You can never have too many knives" -- Logan Nine Fingers
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

DataStage does not follow the Oracle standard for timestamp format strings. But, if your data are already data type timestamp, you should not be fiddling about with format strings in any case. Only if you have to use StringToTimestamp() or similar functions.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply