DATSTAGE EE 7.5.1.A and oracle timestamp format

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
NDE
Participant
Posts: 3
Joined: Tue Aug 08, 2006 1:29 am

DATSTAGE EE 7.5.1.A and oracle timestamp format

Post by NDE »

First sorry for my english, I'm french :lol:

I have to create a job which insert the current date and time in a field in TIMESTAMP format (oracle version is 10.2.0)


I can't transform the field in DATE format.
I can't had colums in the table

I tried to do it with varchar format but each time I got the same message:

Oracle_Enterprise_0: Column NDE_TS has an unsupported type.

(Oracle_Enterprise_0 is the default name of the stage)

Someone has a solution ?
NDE
Participant
Posts: 3
Joined: Tue Aug 08, 2006 1:29 am

Post by NDE »

OK, sorry, :oops:

Can you lock or delete this topic, I'm goind to create it at the right place.

thx!
Post Reply