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



Joined: 12 Oct 2018
Posts: 1

Points: 16

Post Posted: Fri Oct 12, 2018 10:58 am Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Unix
I am having trouble reading a delimited file thru sequential file stage. It is a tab delimited file with 10 columns. My formatting options are
Final Delimter :None (tried with End too)

Delimiter = tab
Null field Value = ''
Quote = None

I am reading all the fields as Varchar. I am seeing the below error. The first value is the Company_Code.


##W IIS-DSEE-TFIG-00194 13:21:31(000) <STG_FILE,0> Delimiter for field "COMPANY_CODE" not found; input: {2 6 7 6 | 1 0 | 1 0 | 0 0 0 1 1 9 5 5 7 1 | W E | 0 0 0 | 0 0 0 1 1 9 5 5 7 1 | 20 20 20 20 20 20 20 20 20 20 | 0 0 0 0 0 0 0 0 | 0 0 0 0 0 0 0 0 0 0 0d}, at offset: 0
##W IIS-DSEE-TOIX-00154 13:21:31(001) <STG_FILE,0> Import warning at record 0.
##W IIS-DSEE-TOIX-00018 13:21:31(002) <STG_FILE,0> Import unsuccessful at record 0.


Please help.
ray.wurlod

Premium Poster
Participant

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

Joined: 23 Oct 2002
Posts: 54407
Location: Sydney, Australia
Points: 295092

Post Posted: Fri Oct 12, 2018 2:55 pm Reply with quote    Back to top    

Welcome aboard.

It seems that your file is not tab delimited but, instead, pipe-delimited.
Change the delimiter property to "|".

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
currently hiring: Canberra, Sydney and Melbourne (especially seeking good business analysts)
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: 54407
Location: Sydney, Australia
Points: 295092

Post Posted: Fri Oct 12, 2018 2:57 pm Reply with quote    Back to top    

Never believe what anyone tells you about metadata of text files. Always check.

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
currently hiring: Canberra, Sydney and Melbourne (especially seeking good business analysts)
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: 42791
Location: Denver, CO
Points: 220555

Post Posted: Sun Oct 14, 2018 7:35 am Reply with quote    Back to top    

Amen Brother!

...then wait for the inevitable mismatch between the test files they sent you and what shows up the first day in production. Wink

_________________
-craig

"I don't mind you comin' here and wastin' all my time time"
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