Extracting the data in sequential file

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
monaz
Participant
Posts: 98
Joined: Sat Aug 23, 2008 3:14 am

Extracting the data in sequential file

Post by monaz »

Hi All,

I am desigining the a server job for extracting of data from the tableA and loading into sequential file.Job finished successfully

Next i am calling the sequential file in parallel job and performing some transformation

The problem is that i job is finished wiht the warnings as
Bad trailing quote character at field "transaction_dt"; looking for '34' but found ' ', at offset: 48
##W TOIX 000154 05:52:56(001) <Copy_of_SeqTdivident,0> Import warning at record 0:

So transaction_dt" is the datetime feild in the table and i used as timestamp in the datastage source.

Please suggest what needs to be done.
Aquilis
Participant
Posts: 204
Joined: Thu Apr 05, 2007 4:54 am
Location: Bangalore
Contact:

Post by Aquilis »

Try reading it as varchar value from the sequential file.
Aquilis
Post Reply