Error while viewing Sequential file:Readdelimited to manycol

Orieos · Post by **Orieos** » Tue Dec 28, 2004 6:42 am

Hi,

Does your file have a separator character?

if it doesn't check the sizes of the columns that you are passing to DS.

they must match the size of the file.

Hope it helps

Ricardo Soeiro

ogmios · Post by **ogmios** » Tue Dec 28, 2004 6:42 am

Check your input file outside of DataStage e.g. in Wordpad. My guess is that you will see that some of the columns will contain the delimiter itself which will confuse DataStage.

E.g. if your delimiter is a ',' and some column contains a ',' this can cause such problems.

Or maybe you're just receiving a input file of the wrong format.

Ogmios

gauravb · Post by **gauravb** » Tue Dec 28, 2004 7:57 am

Hey this worked when i changed e delimited to 191and put Quote Char as 000 and it worked .........
Thanks

ray.wurlod · Post by **ray.wurlod** » Tue Dec 28, 2004 3:05 pm

How did such a simple flaw ever get into production? May I suggest that you investigate your test and verification procedures?

DSXchange

Error while viewing Sequential file:Readdelimited to manycol

Re: Error while viewing Sequential file:Readdelimited to man