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
 

 

how to catalog the list of datasets to a single dataset

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

New User


Joined: 06 Jan 2008
Posts: 11
Location: India

PostPosted: Thu Sep 25, 2008 4:36 pm    Post subject: how to catalog the list of datasets to a single dataset
Reply with quote

hi,

i want to catalog a list of datasets into a single dataset.
for example: my files would be of the naming convention:
"HLQ.MY.DATASET.MMMDDYYA.COL"
"HLQ.MY.DATASET.MMMDDYYB.COL"

So, when i give "HLQ.MY.DATASET.*" all the datasets that start with this name should be written to another dataset using JCL.

Note: I cannot use REXX.

Thank you,
Deepa
Back to top
View user's profile Send private message

expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Thu Sep 25, 2008 4:48 pm    Post subject:
Reply with quote

It is not at all clear what you want to do. Please explain your requirement fully.
Back to top
View user's profile Send private message
hchinnam

New User


Joined: 18 Oct 2006
Posts: 73

PostPosted: Thu Sep 25, 2008 5:01 pm    Post subject:
Reply with quote

Why do you want to do it in JCL.

There is a command called SAVE, which might worth trying.
Back to top
View user's profile Send private message
Deepa Natarajan

New User


Joined: 06 Jan 2008
Posts: 11
Location: India

PostPosted: Thu Sep 25, 2008 5:20 pm    Post subject:
Reply with quote

using JCL, i want to copy as set of datasets that start with a particular name.

for eg: if ig give, HLQ.MMM.MYDATA.* , then all the datasets that start with HLQ.MMM.MYDATA.* should get copied to a PS file.

i should do this in JCL for a daily job. please let me know if this is still unclear!
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Thu Sep 25, 2008 5:30 pm    Post subject:
Reply with quote

Have you looked at IDCAMS LISTCAT ?

And why can't you use REXX
Take a look HERE - it's one I've written earlier
Back to top
View user's profile Send private message
Deepa Natarajan

New User


Joined: 06 Jan 2008
Posts: 11
Location: India

PostPosted: Thu Sep 25, 2008 5:42 pm    Post subject:
Reply with quote

I saw your post. but unfortunately, I can't use REXX in this particular JCL code. (My client says so).

I tried IDCAMS LISTCAT, but for that I have to give the entire file name!!

is there no way other than REXX?
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Thu Sep 25, 2008 5:43 pm    Post subject:
Reply with quote

Deepa Natarajan wrote:

i tried IDCAMS LISTCAT, but for tat v have to give the entire file name!!

Well, your client is crazy !!!

Take a good long read of the IDCAMS manual and pay particular attention to the LEVEL parameter.
Back to top
View user's profile Send private message
superk

Moderator Team Head


Joined: 26 Apr 2004
Posts: 4648
Location: Raleigh, NC, USA

PostPosted: Thu Sep 25, 2008 6:06 pm    Post subject: Reply to: how to catalog the list of datasets to a single da
Reply with quote

Why can't you code a (non-REXX) program and use the ISPF LMDLIST Service to create a list of datasets based on a specified wildcard? There was a recent topic here.
Back to top
View user's profile Send private message
saravanans4

New User


Joined: 01 Sep 2003
Posts: 26

PostPosted: Fri Oct 10, 2008 1:18 pm    Post subject: Re: how to catalog the list of datasets to a single dataset
Reply with quote

Deepa Natarajan wrote:
hi,

i want to catalog a list of datasets into a single dataset.
for example: my files would be of the naming convention:
"HLQ.MY.DATASET.MMMDDYYA.COL"
"HLQ.MY.DATASET.MMMDDYYB.COL"

So, when i give "HLQ.MY.DATASET.*" all the datasets that start with this name should be written to another dataset using JCL.

Note: I cannot use REXX.

Thank you,
Deepa


Hi Deepa,

You can use the following JCL, surely it will help you.

//STEP1 EXEC PGM=IDCAMS
//SYSPRINT DD SYSOUT=Give the output dataset name,
// DISP=SHR
//SYSIN DD *
LISTCAT LVL(HLQ.MY.DATASET) NONVSAM
/*
Thats all. Instead of NONVSAM you can give ALL keyword also. It will list all the dataset name with this same qualifier. I used this JCL. This is simple and best.


Thanks,
Santha.
Back to top
View user's profile Send private message
Deepa Natarajan

New User


Joined: 06 Jan 2008
Posts: 11
Location: India

PostPosted: Fri Oct 10, 2008 3:57 pm    Post subject:
Reply with quote

Thanks a lot Santha :-)

Thanks,
Deepa
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 SQL query to run through list of valu... Ni3-db2 DB2 14 Wed Dec 14, 2016 9:52 am
No new posts DUMP DATASETS VS TRACE DATASETS! lind sh CICS 4 Tue Dec 06, 2016 11:31 pm
No new posts FTP - JCL failed while passing FTP co... Suneetha1612 JCL & VSAM 12 Wed Nov 16, 2016 7:33 pm
No new posts Two Selects in a single select query Rohit Umarjikar DB2 1 Fri Nov 04, 2016 8:46 pm
No new posts Cobol list of programs being called biswajit.dattagupta COBOL Programming 5 Tue Nov 01, 2016 2:10 am


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