Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

LISTCAT to exclude certain datasets(NON VSAM)

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
yogi.47eie

New User


Joined: 16 Aug 2006
Posts: 28
Location: india

PostPosted: Mon Apr 13, 2009 4:52 pm    Post subject: LISTCAT to exclude certain datasets(NON VSAM)
Reply with quote

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
View user's profile Send private message

Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Mon Apr 13, 2009 5:19 pm    Post subject:
Reply with quote

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
View user's profile Send private message
yogi.47eie

New User


Joined: 16 Aug 2006
Posts: 28
Location: india

PostPosted: Tue Apr 14, 2009 1:28 pm    Post subject: Reply to: LISTCAT to exclude certain datasets(NON VSAM)
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts REXX to get the all datasets name parasmalik20 CLIST & REXX 5 Tue Jul 18, 2017 9:10 pm
No new posts VSAM Space Allocation mrgnndhmk JCL & VSAM 7 Sat Apr 22, 2017 12:42 am
This topic is locked: you cannot edit posts or make replies. SDSF multiple spool datasets extracte... PJAlarcon CLIST & REXX 1 Fri Apr 21, 2017 10:50 pm
No new posts LISTCAT on a dataset with symbolic pa... shreya19 JCL & VSAM 5 Fri Apr 07, 2017 5:43 pm
No new posts Edit large number of datasets (QSAM) zh_lad TSO/ISPF 3 Tue Apr 04, 2017 6:08 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us