I have job where it reads from sequential file and stores the data in dataset.There is one column in the sequential file named VERSION(say) and it's defined as VARCHAR(1).
Now in the file if any records are coming say 'AB' for VERSION then it truncates up to 'A' in both 8.5 and 11.3.But in 11.3 am getting one warning like the below where in 8.5 no warnings have been generated.
External string too long. Imported only 1 out of 2 external characters. Ignoring last 1 characters up to delimiter.
I have checked the message handler also,bit nothing is defined in 8.5.
Any idea on this?
Sequential file behaviour
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 152
- Joined: Mon Mar 07, 2011 6:16 am
Sequential file behaviour
Soumya
-
- Participant
- Posts: 152
- Joined: Mon Mar 07, 2011 6:16 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Agreed. I have seen numerous jobs give new warnings in 11.3 as compared to 8.7 (no warnings), and in all cases so far, the job has had something coded incorrectly, like a data type, or a delimiter, or other setting mismatch. Fix the job design in 11.3 and the warning disappears.
Choose a job you love, and you will never have to work a day in your life. - Confucius