DSXchange

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.

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.

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.

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.