DSXchange

Hello Everyone,

I was just wondering if it was possible to read a specific record from a sequential file source stage. I know there is a filter clause which can help me eliminate headers, footers and so on but I was wondering if it would be possible to extract say JUST the nth row of a file.

Thanks!

use UNIX shell scripts and add in Before jobsubroutines.

Thanks
Rama

Hi ,

You can use the following command in filter option present in sequential file head -5 filename | tail -1.This will give 5th row .Also you can use rownumber option in sequential file stage and there by use some constraints or filter to get desired rownumber.

Still, the answer to the question is 'no'. It's sequential media and thus somehow you have to read the first 8 records to get to the 9th one.

You can locate the nth record and read them alone using unix commands.

we can use the sample stage to get the Nth record..?

There are all kinds of ways to pick the record(s) you want from a sequential file input stream, including just the Nth record. Gonna go all anal here and reiterate that the answer to the question that was asked - I was just wondering if it was possible to read a specific record from a sequential file source stage - is still no. The only way to get to the Nth record in a sequential file is to read through all of the "N-1th" records first. Something has to do that.

There is one way, and that is to use an ODBC driver for text files.

Just don't expect speed as well as functionality.