Issue while reading a sequential file
Environment : IS 8.5 Fixpack 1 on Windows Server 2008
NLS : Project default (ASCL_MS1252)
Delimiter : Tab
Final Delimiter : End
Record delimiter : Unix Newline / Null (does not matter)
Issue : I am trying to read a sequential file having tab delimiter. For example the data looks as below
ColA ColB ColC
123 456 ABCD
The datatypes for these columns defined are ColA varchar(10 Not Null) , ColB Varchar(50),ColC Varchar(20).
When i view the sequential file or write to any DATASET I see the data displayed with spaces between each characters.
ColA ColB ColC
1 2 3 4 5 6 A B C D
Not sure why this is happening !
SPACES BETWEEN CHARACTERS WHILE READING SEQUENTIAL STAGE
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 40
- Joined: Thu Jul 10, 2008 12:45 pm
SPACES BETWEEN CHARACTERS WHILE READING SEQUENTIAL STAGE
Srikanth Reddy
Integration Consultant
Integration Consultant
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 40
- Joined: Thu Jul 10, 2008 12:45 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 40
- Joined: Thu Jul 10, 2008 12:45 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: