DSXchange

Hi,

I am trying to load the data into Oracle table using datastage direct load method. I am unable to insert the timestamp field into the table having datatype as timestamp(6). I have converted my data to the timestamp format supported by datastage.

I am getting error as unsupported type.

can anybody help me out in this?

Thanks in advance !!

Regards,
Abhijit

Welcome Aboard,
I have never seen timestamp with length 6. You sure you got the length right?

timstamp datatype with 6 digits for microseconds

WHen you say direct load, you mean using the OCI Load stage? If yes then make sure the date is in the format YYYY-MM-DD 24HH:MM:SS.nnnnnn before sending it to the load stage.
If you are using the API stage and doing an INSERT, then let OCI stage take care of the format in TO_DATE() function. I think you need to provide the format YYYY-MM-DD 24HH:MM:SS.FF6

abhijitr wrote:timstamp datatype with 6 digits for microseconds

I have used following conversion

StringToTimestamp('2007-02-02 05:23:56.000025',"%yyyy-%mm-%dd %hh:%nn:%ss.x")

but still i am facing the problem

Try giving .6 instead of .x

DSguru2B wrote:Try giving .6 instead of .x

I have tried that also still its giving me unsuppoted type error

abhijitr wrote:

DSguru2B wrote:Try giving .6 instead of .x

I have tried that also still its giving me unsuppoted type error

IS there any way i can specify the ".ctl" file to this loader same as conventional SQL Loader in which i can specify the timestamp format till microseconds.

I would defer to the folks who have had experience with timestamp microseconds and sql loader.