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.
Error reading thru Sequential File stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 1
- Joined: Fri Oct 12, 2018 10:44 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: