DSXchange

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 wrote:Try giving .6 instead of .x

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

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

timstamp datatype with 6 digits for microseconds

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 anybod...