View previous topic :: View next topic
|
Author |
Message |
yogi.47eie
New User
Joined: 16 Aug 2006 Posts: 45 Location: india
|
|
|
|
Hi all ,
I have listcat as below:
LISTCAT LEVEL('PROD.ABC') NAME NONVSAM
Its listing all the files like
PROD.ABC.A
PROD.ABC.B
PROD.ABC.C
PROD.ABC.D
I want to exclude the file PROD.ABC.D files .
I have tried the option as below in the IDCAMS step:
Code: |
//STEP02 EXEC PGM=IDCAMS
//SYSOUT DD SYSOUT=*
//SYSPRINT DD DSN=DVLP.LISTCAT.FILES
// UNIT=SYSDA,SPACE=(CYL,(1,2),RLSE),DISP=(,CATLG,CATLG)
//SYSIN DD *
LISTCAT LEVEL('PROD.ABC.A') NAME NONVSAM
LISTCAT LEVEL('PROD.ABC.B') NAME NONVSAM
LISTCAT LEVEL('PROD.ABC.C') NAME NONVSAM
/*
|
Can you advise if there any way to exclude the PROD.ABC.D flies in a single statement, instead using the below 3 statements
LISTCAT LEVEL('PROD.ABC.A') NAME NONVSAM
LISTCAT LEVEL('PROD.ABC.B') NAME NONVSAM
LISTCAT LEVEL('PROD.ABC.C') NAME NONVSAM
Yogi |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
AFAIK, not with IDCAMS.
Other alternative which I can think of is you can use the output of IDCAMS as an input to a SORT where only those files will be "send" to output whch has "NONVSAM string concateneted" to them. |
|
Back to top |
|
|
yogi.47eie
New User
Joined: 16 Aug 2006 Posts: 45 Location: india
|
|
|
|
Thanks Anuj,This will make simple,
we do have the same scenario in a rexx routine as well.where we are passing the parameter as PROD.ABC,what ever datasets are there with PROD.ABC*,those datasets will get processed.I need to exclude the PROD.ABC.D dataset means,should i need to pass PROD.ABC.A ,B,C separately or are there any other way to exclude in Rexx routine itself
//STEP02.SYSTSIN DD *
PROFILE NOPREFIX MSGID
ISPSTART CMD(%MERG PROD PROD.ABC 1)
/*
In the Rexx routine MERG will process all the files PROD.ABC* which we don't want to do???
Thanks in a advance
Yogi |
|
Back to top |
|
|
|