SEQ File

naren6876 · Post by **naren6876** » Wed Aug 03, 2011 10:19 am

Hi All,

How can we read a sequential file data based on Column Header as i am interested in only few columns.

Any input would be highly appreciated.

Thanks in advance.

chulett · Post by **chulett** » Wed Aug 03, 2011 11:02 am

You have to 'read' all of the columns, that's the nature of sequential media. Feel free to immediately drop the columns you don't need but they must be read.

arunkumarmm · Post by **arunkumarmm** » Mon Aug 08, 2011 1:50 pm

Will that be possible if we use ODBC stage to read a sequential file? I'm sure we can use ODBC stage to read a sequential file, I even tried but couldnt make it to work.

chulett · Post by **chulett** » Mon Aug 08, 2011 2:40 pm

I would assume an ODBC text driver could read the file and pass back only certain columns but under the covers it would still read each record in its entirety. I don't see the need to complicate this, however, read the record and only pass along the columns you need.