seqential file issue

[harish_s_ampeo]

hi,
i have job where i extract data from db2 table and populate to a sequential file.
each field value is delimited with pipe & my last filed is a decimal field.

am getting juck value for the last field but the job completes(finshes) sucessfully, but job which take this sequential file as source file abort because of junck data.

i searched for solution for this issue in the forum but couldn't get the resolution.

Please let me know how to resolve this issue.

sample data which iam getting ::
store no | dept no | div no | data | Actual sales
2|3|4|02-02-2009|^H
2|6|3|02-02-2009|&*
2|8|6|02-02-2009|{E




Thanks,
Harish

[ArndW]

It looks like you specified "binary" for the decimal output field in your column attributes.

[Kryt0n]

Or an offset (still within column definitions)... we had something similar for a Sybase table def, can't remember what the output looked like but do remember we weren't getting what we expected and was due to an offset in the column definition

Did you import the table definition from DB2?