How to count the rows ?parallel jobs.

ketanshah123 · Post by **ketanshah123** » Thu Feb 08, 2007 4:25 am

Hi

In my sequential file (Source) there are more than 1000 records
I want to get first 500 records from it for further processing.
and wants to pass rest all records to another temporary file.

so my query is , In parallel job how can I count and get first 500 records from sequential file?

tried with @inrownum system fuction but not getting desired result.

ArndW · Post by **ArndW** » Thu Feb 08, 2007 5:57 am

You can force sequential execution so that you only have one process, then use @INROWNUM to limit output from a link to 500.

ketanshah123 · Post by **ketanshah123** » Thu Feb 08, 2007 6:46 am

Thnx........ :D