External string too long

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
spuli
Participant
Posts: 40
Joined: Thu Apr 09, 2015 12:13 pm

External string too long

Post by spuli »

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
Thanks,
Sai
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

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.
-craig

"You can never have too many knives" -- Logan Nine Fingers
spuli
Participant
Posts: 40
Joined: Thu Apr 09, 2015 12:13 pm

Post by spuli »

Thanks Chulett for your quick response.

The provided link has the needed information.

Do you have any idea to know the column that is getting truncated?

Thanks in advance.
Thanks,
Sai
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Other than what I already posted? No.
-craig

"You can never have too many knives" -- Logan Nine Fingers
spuli
Participant
Posts: 40
Joined: Thu Apr 09, 2015 12:13 pm

Post by spuli »

Thanks Chulett.
Thanks,
Sai
rakesh.puli
Premium Member
Premium Member
Posts: 29
Joined: Wed Mar 22, 2017 10:45 pm

Post by rakesh.puli »

Hi Chulett,

I have a similar issue. But the environmental variable APT_IMPORT_NOWARN_STRING_FIELD_OVERRUNS=1 shown in the link you provided is not available in Datastage 11.3. So I am not able to suppress the warning.Could you please tell me anyother way to cremove this warning.

Thanks
Rakesh
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

There are ones you need to create, there are plenty that won't be listed until you manually add them. I'm assuming this is one of them.
-craig

"You can never have too many knives" -- Logan Nine Fingers
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

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.
Post Reply