DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
spuli
Participant



Joined: 09 Apr 2015
Posts: 40

Points: 305

Post Posted: Wed Mar 30, 2016 11:56 am Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Additional info: Imported only 1 out of n external characters. Ignoring last
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

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 42944
Location: Denver, CO
Points: 221471

Post Posted: Wed Mar 30, 2016 12:14 pm Reply with quote    Back to top    

http://www-01.ibm.com/support/docview.wss?uid=swg21962771

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

The Old Ones were, the Old Ones are, and the Old Ones shall be. Not in the spaces we know, but between them. They walk serene and primal, undimensioned and to us unseen.
Rate this response:  
Not yet rated
spuli
Participant



Joined: 09 Apr 2015
Posts: 40

Points: 305

Post Posted: Wed Mar 30, 2016 12:19 pm Reply with quote    Back to top    

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
Rate this response:  
Not yet rated
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 42944
Location: Denver, CO
Points: 221471

Post Posted: Wed Mar 30, 2016 12:22 pm Reply with quote    Back to top    

Other than what I already posted? No.

_________________
-craig

The Old Ones were, the Old Ones are, and the Old Ones shall be. Not in the spaces we know, but between them. They walk serene and primal, undimensioned and to us unseen.
Rate this response:  
Not yet rated
spuli
Participant



Joined: 09 Apr 2015
Posts: 40

Points: 305

Post Posted: Wed Mar 30, 2016 1:42 pm Reply with quote    Back to top    

Thanks Chulett.

_________________
Thanks,
Sai
Rate this response:  
Not yet rated
rakesh.puli



Group memberships:
Premium Members

Joined: 22 Mar 2017
Posts: 16

Points: 136

Post Posted: Mon Feb 25, 2019 6:13 pm Reply with quote    Back to top    

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
Rate this response:  
Not yet rated
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 42944
Location: Denver, CO
Points: 221471

Post Posted: Mon Feb 25, 2019 6:53 pm Reply with quote    Back to top    

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

The Old Ones were, the Old Ones are, and the Old Ones shall be. Not in the spaces we know, but between them. They walk serene and primal, undimensioned and to us unseen.
Rate this response:  
Not yet rated
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54514
Location: Sydney, Australia
Points: 295617

Post Posted: Wed Feb 27, 2019 4:33 pm Reply with quote    Back to top    

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

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours