Datastage direct loader

abhijitr · Post by **abhijitr** » Wed Feb 21, 2007 10:51 am

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

DSguru2B · Post by **DSguru2B** » Wed Feb 21, 2007 10:54 am

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

abhijitr · Post by **abhijitr** » Wed Feb 21, 2007 11:07 am

timstamp datatype with 6 digits for microseconds

DSguru2B · Post by **DSguru2B** » Wed Feb 21, 2007 11:20 am

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 · Post by **abhijitr** » Wed Feb 21, 2007 11:24 am

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

DSguru2B · Post by **DSguru2B** » Wed Feb 21, 2007 11:29 am

Try giving .6 instead of .x

abhijitr · Post by **abhijitr** » Wed Feb 21, 2007 12:32 pm

DSguru2B wrote:Try giving .6 instead of .x

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

abhijitr · Post by **abhijitr** » Wed Feb 21, 2007 1:02 pm

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.

DSguru2B · Post by **DSguru2B** » Wed Feb 21, 2007 1:17 pm

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