DSXchange

Hi
Im trying to convert string to timestamp and I get the following error

APT_CombinedOperatorController(2),2: Conversion error calling conversion routine timestamp_from_string data may have been lost

the input column value from the sequential file is for example

CRT_DATE 2006-03-15 19:39:12

I need to insert this into a timestamp column in oracle

I've also noticed in the peek stage that some values are :
Peek_63,2: CRT_DATE:*******************

Help on this is much appreciated.

Thanks

Show us your syntax.

Hi
Thanks
It was not reading the null values, specified the null value, and the job is working fine now.

Thanks