The task is to split large dataset (i.e. 300000 records) into smaller parts of n records each. n is constant value, let's say 40000.

It can be done in several using COPY with SKIPREC x*n STOPAFT (x+1)*n, however this method requires several DFSORT steps.
Can it be done in one step ?

--
Radoslaw Skorupka
Lodz, Poland

----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html

Reply via email to