SPACES BETWEEN CHARACTERS WHILE READING SEQUENTIAL STAGE
Posted: Wed Nov 09, 2011 3:52 pm
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 !
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 !