Error reading thru Sequential File stage

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
vvelagapudi
Participant
Posts: 1
Joined: Fri Oct 12, 2018 10:44 am

Error reading thru Sequential File stage

Post by vvelagapudi »

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
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Welcome aboard.

It seems that your file is not tab delimited but, instead, pipe-delimited.
Change the delimiter property to "|".
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Never believe what anyone tells you about metadata of text files. Always check.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

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

"You can never have too many knives" -- Logan Nine Fingers
Post Reply