SPACES BETWEEN CHARACTERS WHILE READING SEQUENTIAL STAGE

srireddypunuru · Post by **srireddypunuru** » 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 !

ray.wurlod · Post by **ray.wurlod** » Wed Nov 09, 2011 8:04 pm

View the data how?

srireddypunuru · Post by **srireddypunuru** » Wed Nov 09, 2011 8:33 pm

Viewing using sequential stage view option

ray.wurlod · Post by **ray.wurlod** » Wed Nov 09, 2011 11:39 pm

Try reading the file with something else, like WordPad.

srireddypunuru · Post by **srireddypunuru** » Thu Nov 10, 2011 8:33 am

Ray,

We have used textpad and opened the file able to see the contents of the file but not with the sequential Stage.

Thanks
Sri

ray.wurlod · Post by **ray.wurlod** » Thu Nov 10, 2011 3:21 pm

And do the spaces exist when you use TextPad?