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
error Loading from Sequential File
Moderators: chulett, rschirm, roy
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)
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)
Regards,
Shree
785-816-0728
Shree
785-816-0728
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: