Hi Radoslaw, In respect to your post "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 ?" I cannot say whether DFSORT can do it in one step, as I have not investigated that, but IDCAMS REPRO will do it, see "www.kmsitltd.co.uk/fsplit.html" the IDCAMS step shown splits the file created by the first step of the example. It is likely thatif DFSORT can do it, it may be faster. Kind regards - Terry Terry Sambrooks Director KMS-IT Limited 228 Abbeydale Road South Dore Sheffield S17 3LA UK Tel: +44 (0)114 262 0933 WEB: www.legac-e.co.uk www.kmsitltd.co.uk Reg: England & Wales 3767263 at the above address All outgoing E-mails are scanned but it remains the recipients responsibility to ensure that their system is protected from viruses, trojans, worms, and spy-ware. ---------------------------------------------------------------------- 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
