DATSTAGE EE 7.5.1.A and oracle timestamp format

[NDE]

First sorry for my english, I'm french

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

To test I created a little table like this:
create table NDE_TEST (
NDE_TS TIMESTAMP
);

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 ?

[kumar_s]

I tried to do it with varchar format

You need to convert it before loading into the table. Either through to_date() function available in oracle, or the inbuild funcions available in datastage.