ROW NUMBER for sequential file stage

fmou · Post by **fmou** » Fri Jul 29, 2011 10:18 pm

Hi,

1. Is there an option to add a ROW NUMBER COLUMN to the reading sequential file in the sequential file stage? I read and searched through the Sequential File Stage section from the Parallel Job Developer's Guide, Version 7.5.1, but didn't find any.

2. Is there any way to pass how many rows are read from the sequential file to next stages?

Thanks

Ravi.K · Post by **Ravi.K** » Fri Jul 29, 2011 10:22 pm

There is a property called RowNumberColumn. Please look at properties.

chulett · Post by **chulett** » Sat Jul 30, 2011 7:00 am

1. It looks like that option was added in the 8.x release, so no.

2. You can generate the current row number if you are careful with any partitioning. If you need to know the total number of records while the job runs, you'll need to count them ahead of time and pass the count in as a job parameter.

fmou · Post by **fmou** » Sat Jul 30, 2011 9:42 am

You can generate the current row number if you are careful with any partitioning.

You are talking about not in the sequential file stage but in the following stage, eg, a transformer, right?

chulett · Post by **chulett** » Sat Jul 30, 2011 10:16 am

Yes, via a stage variable in a transformer.