DSXchange

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

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.

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.

Other than what I already posted? No.

Thanks Chulett.

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

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.

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