000255 000431 C BC
R SKD 1740 OUT 1925 G/T D23A PSV 1925 CGO 1819 R MEL RTG N 390 MEL.'\n'
000125 000139 888'\n'
02000 002014 CO 888'\n'
001435 001508 O K AC CREW REPORTS LH FAIRING TO FUSELAGE RETRACTABLE'\n'
Above is fixed width file except for the last record which can be variable. So have defined them as varchar with null field value as Null.The two records in the middle are being reject with Input buffer overrun at field because the last field is null.
I am not sure how to get around this, can someone please advice.
Input buffer overrun
Moderators: chulett, rschirm, roy
Input buffer overrun
Regards,
Ganesh
Ganesh
-
- Premium Member
- Posts: 72
- Joined: Mon Jul 06, 2009 9:34 pm
- Location: Sydney
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Your original data, as posted, lacked this \n, which is why I asked.
Can you read the file as if it has only one VarChar field? Does that work successfully? If so, you can parse the rows in a Transformer stage. (This can actually be more efficient, because the parsing occurs in a parallel stage.) Your parse could be based on the number of space characters in the line - if three, the fifth field is empty/null. If more, the fifth field contains data.
Can you read the file as if it has only one VarChar field? Does that work successfully? If so, you can parse the rows in a Transformer stage. (This can actually be more efficient, because the parsing occurs in a parallel stage.) Your parse could be based on the number of space characters in the line - if three, the fifth field is empty/null. If more, the fifth field contains data.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.