Last row in a Sequential file

naren6876 · Post by **naren6876** » Tue Jun 27, 2006 8:19 am

Hi all,

Is tehre anyway that i can find a last row number ina sequential file which can be used in constraint as @OUTROWNUM = Lastrownum?.

Any input would be highly appreciated.

Thanks in advance.

kumar_s · Post by **kumar_s** » Tue Jun 27, 2006 8:31 am

Use this in a command activity prior to the job being called, and pass the output as parameter.

Code: Select all

wc -l <filename> | cut -f1 -d ' '

kcbland · Post by **kcbland** » Tue Jun 27, 2006 8:44 am

Run all data thru an Aggregator and use LAST derivation for all columns with no GROUP set.

kumar_s · Post by **kumar_s** » Tue Jun 27, 2006 8:48 am

This gives the last record. If you need the last record no, simply count the total no of record using aggregator.

ray.wurlod · Post by **ray.wurlod** » Tue Jun 27, 2006 4:28 pm

Why not just use tail -1 filename as a filter in the Sequential File stage that reads the file?