I have encountered a problem with timestamp type. I have a field (with sql type varchar) given by source data as : 2002-01-11-10.04.50.000000. This is a field that showing us the date and time.
I have created a job to transform this data to timestamp by using the command : StringToTimestamp(DSLink2.DATIME,"%yyyy-%mm-%dd %hh:%nn:%ss")
After that, I used the output of this data (setting the sql type as timestamp) as a sequential file input to load into Oracle in another parallel job. Unfortunately, i could not view the data with the error message:
However, if i set the sql type as varchar, then i can view the data successfully.##W TOIX 000000 11:20:46(000) <Sequential_File_7,0> Field "DATIME" delimiter not seen, at offset: 218
##W TOIX 000154 11:20:46(001) <Sequential_File_7,0> Import warning at record 0:
##W TOIX 000018 11:20:46(002) <Sequential_File_7,0> Import unsuccessful at record 0:
##I TOIX 000163 11:20:46(003) <Sequential_File_7,0> Import complete. 0 records imported successfully, 1 rejected.
**VIEWDATA ROW LIMITER HIT**
I am wondering whether i have done it correctly and how can I view the data by setting it to timestamp type. Thanks in advance for ur opinion and help.