error Loading from Sequential File

[cosec]

Hi

DB2 Source - > Sequential File - > Target

If I set the sequential file(both input/output) to delimitted my job runs fine with no warnings but if i set it to fixed length I get the following warning :


djBatRcpt..DB2_UDB_API_3.IDENT2: At row 1, link 'DSLink4', while processing column 'ADJ_BAT_RCPT_ID', value truncated to ' 2006'.


Pls Help resolve this error.

Thanks

[Sreedhar]

I understand from you posting that the job will run successfully with out any warnings if given as delimited, but fails when said as Fixed width.


With my exp I can only say that the fields declared as CHAR should be modified to VARCHAR. And also make user that the data is in accordance to the Metadata defined.


If that is an integer field or Numeric field make sure that you are giving it enough space to accommodate the input field

Do let us know the results(if there is any changes)

[ray.wurlod]

Get the fixed widths RIGHT.