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 how to recover an uncataloged VSAM da... archanamuthukrishnan All Other Mainframe Topics 3 Wed Jan 11, 2017 6:18 pm
No new posts Underlying DB2 VSAM LDS - SMF recording vasanthz All Other Mainframe Topics 6 Thu Jan 05, 2017 4:20 am
No new posts DUMP DATASETS VS TRACE DATASETS! lind sh CICS 4 Tue Dec 06, 2016 11:31 pm
No new posts BWO option in VSAM blayek CICS 3 Sat Nov 05, 2016 10:47 am
No new posts Single COPY CICS TS datasets and when... Kyle Carroll CICS 2 Tue Oct 11, 2016 9:47 pm


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