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.
How to count the rows ?parallel jobs.
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 88
- Joined: Wed Apr 05, 2006 1:04 am
You can force sequential execution so that you only have one process, then use @INROWNUM to limit output from a link to 500.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>