DSXchange

Thanks a lot Ray ,problem solved .

Regards,
Sam

Hi Ray , i tried this code and it works fine without warnings when writing to a oracle table ,however for testing i was writing to a sequential file and was getting the same error why is that so ? should the syntax be different when writing to a seq file ? IF ((Lnk_Smac_Transaction_Read.SETTLEDATE)=...

Hi Ray ,

Did you mean the timestamp part should have values ? could you please let me know how to modify my statement .

thanks,
Sam

Hi Chullete, the error mesg as in the log "APT_CombinedOperatorController,0: Conversion error calling conversion routine timestamp_from_string data may have been lost" since i could not pass a null to the OCI stage i used this logic in the transformer ,i hardcoded the date if the input is null, stil...

Hi Ray,Chullett,

The error in the job log is "Conversion error calling conversion routine timestamp_from string ".

Thanks,
Sam

Hi , I know that this topic has been covered several times in this forum but i couldnt find the exact match. here is my scenario I am reading from a csv file and writing to a oracle table date(varchar 8 )in seq file date(timestamp) in oracle(no size specified) When there is date value in the csv fil...