Hi All,
I am trying to load a file with 700 fields into a table. I used sequential file stage to read the file. I am getting the below warning message.
"Input_Stage,0: External string too long. Imported only 1 out of 2 external characters. Ignoring last 1 characters up to delimiter."
How do I know which column is causing this warning message.
Appreciate your help!
Thanks
External string too long
Moderators: chulett, rschirm, roy
External string too long
Thanks,
Sai
Sai
http://www-01.ibm.com/support/docview.w ... wg21962771
About all it seems to me you can tell from the message is that it is a 1 character string and it wanted to put 2 characters in it.
About all it seems to me you can tell from the message is that it is a 1 character string and it wanted to put 2 characters in it.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Premium Member
- Posts: 29
- Joined: Wed Mar 22, 2017 10:45 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Just curious, does the file come from a Windows machine? If so, try setting the record delimiter string property to DOS-style, on the assumption that the extra character is Ctrl-M (Char(13)).
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.