nigelosberry
New User
Joined: 06 Jan 2009 Posts: 88 Location: Ggn, IN
|
|
|
|
Hi Experts,
I tried searching the web for "multiple repro cards in 1 idcams sysin" but did not get any clear result. So I am starting a new topic. Apologies if this has already been discussed.
I remember quite well that I saw various IDCAMS cards In my first shop wherein we had multiple Key combinations(i.e. FROMKEY and TOKEY) inside a single sysin card. I gave it many tries today but failed initially when I tried reading multiple range of keys from VSAM file onto a sequential file but no luck.
Finally, I have now figured out a way to use multiple IDCAMS repro commands inside 1 sysin and write the output to a sequential file.
Code: |
//PS030 EXEC PGM=IDCAMS
//VSAMFILE DD DSN=T3.INVSAM.FILE1,
// DISP=(SHR,KEEP,KEEP),
// AMP='BUFSP=849960'
//SEQFILE DD DSN=T3.INVSAM.FILE1.OUTSEQ,
// DISP=(MOD,CATLG,DELETE),
// UNIT=SYSDA,
// SPACE=(10796,(100,10),RLSE),
// DCB=(SYS3.DSCB,DSORG=PS,
// RECFM=VB,LRECL=272,BLKSIZE=0)
//SYSIN DD *
REPRO INFILE(VSAMFILE) -
OUTFILE(SEQFILE) -
FROMKEY('KEY00001') TOKEY('KEY00099')
REPRO INFILE(VSAMFILE) -
OUTFILE(SEQFILE) -
FROMKEY('KEY11111') TOKEY('KEY22222')
|
The trick is to use MOD in the disposition of the output sequential file. Each repro request is considered a separate request and data pertaining to it is "appended" to the output sequential file.
Experts, could you please let me know your views on this.
(1)Can there be any disadvantages of using this?
(2)Any improvement that can be done to it?
Cheers,
Nigel. |
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
If the volume is hundreds of records, stick to it.
If the volume is hundreds of millions of records, consider using sort for performance reasons.
Just my $.02 |
|