Page 1 of 1

SPACES BETWEEN CHARACTERS WHILE READING SEQUENTIAL STAGE

Posted: Wed Nov 09, 2011 3:52 pm
by srireddypunuru
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 !

Posted: Wed Nov 09, 2011 8:04 pm
by ray.wurlod
View the data how?

Posted: Wed Nov 09, 2011 8:33 pm
by srireddypunuru
Viewing using sequential stage view option

Posted: Wed Nov 09, 2011 11:39 pm
by ray.wurlod
Try reading the file with something else, like WordPad.

Posted: Thu Nov 10, 2011 8:33 am
by srireddypunuru
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

Posted: Thu Nov 10, 2011 3:21 pm
by ray.wurlod
And do the spaces exist when you use TextPad?