View previous topic :: View next topic |
Author |
Message |
ed.sam13 Beginner
Joined: 09 Aug 2010 Posts: 31 Topics: 11
|
Posted: Mon Mar 23, 2015 3:23 am Post subject: Question about Multi-Volume Datasets |
|
|
I am using a 1GB multi-volume disk file as input. I want to skip some records based on a condition and then overlay the same file and proceed to the next step for processing. So i have the same file as SORTIN (DISP=SHR) and also as SORTOUT (DISP=(OLD,CATLG,CATLG).
But i am getting only a small subset of records in the output.
When i used DSN=NULLFILE in SORTOUT with the same condition, this is the statistics
Code: | INSERT 0, DELETE 5906
RCD IN 58636343, OUT 58630437 |
But when i give the SORTIN file in SORTOUT with the same condition this is the statistics
Code: | INSERT 0, DELETE 3
RCD IN 2639520, OUT 2639517
|
Is it because the work datasets are all single volume? Is there a way to get around this? |
|
Back to top |
|
|
William Collins Supermod
Joined: 03 Jun 2012 Posts: 437 Topics: 0
|
Posted: Mon Mar 23, 2015 6:54 am Post subject: |
|
|
You'd better show the full sysout from the two steps.
You can't use the same DSN for SORTIN and SORTOUT in a COPY or MERGE operation. You can in a SORT, although I don't regard it as a particularly good idea (ensure you have a back-up of the input, or that it can reasonably be recreated). |
|
Back to top |
|
|
kolusu Site Admin
Joined: 26 Nov 2002 Posts: 12376 Topics: 75 Location: San Jose
|
Posted: Mon Mar 23, 2015 11:17 am Post subject: Re: Question about Multi-Volume Datasets |
|
|
ed.sam13 wrote: | I am using a 1GB multi-volume disk file as input. I want to skip some records based on a condition and then overlay the same file and proceed to the next step for processing. So i have the same file as SORTIN (DISP=SHR) and also as SORTOUT (DISP=(OLD,CATLG,CATLG).
|
ed.sam13,
With DFSORT, for a copy application, the SORTIN data set should not be the same as the SORTOUT data set or any OUTFIL data set because this can cause lost or incorrect data or unpredictable results. _________________ Kolusu
www.linkedin.com/in/kolusu |
|
Back to top |
|
|
|
|