Page 1 of 1

Maximum Columns that can be read by a sequential file

Posted: Tue Jul 06, 2010 12:05 pm
by saikir
Hi All,

I have a crazy requirement where in i will have to ready wider file having more then 2200 columns using a sequntial file stage. I would like to know is there a threshold to the no: columns that can be read by a sequential file.

Any help is appreciated!

Regards,
Sai

Posted: Tue Jul 06, 2010 12:30 pm
by anbu
Yes you can have 2200 columns in a sequntial file stage.

Posted: Wed Jul 07, 2010 12:37 am
by ray.wurlod
The only limit you might strike is if the operating system has a limit on the number of bytes in a line in a file. There is no limit within DataStage per se. Check with your UNIX administrator.

Posted: Tue Aug 03, 2010 1:55 pm
by arunkumarmm
I have used 3500+ columns in one of the job...