How to count the rows ?parallel jobs.
Posted: 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.
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.