IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Is there any way to download the dataset names


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Bhanupratap Natva

New User


Joined: 13 Jul 2007
Posts: 8
Location: Hyderabad

PostPosted: Mon Aug 24, 2009 6:17 pm
Reply with quote

Is there any way to download the dataset names which start with a particular HLQ?
Back to top
View user's profile Send private message
Escapa

Senior Member


Joined: 16 Feb 2007
Posts: 1399
Location: IL, USA

PostPosted: Mon Aug 24, 2009 6:20 pm
Reply with quote

Probably you can write small rexx program to get the names with required criteria and write all in one PS.

Transfer this PS to your local machine using conventional way you are using at your shop and load it into EXCEL.
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10873
Location: italy

PostPosted: Mon Aug 24, 2009 6:22 pm
Reply with quote

no need to write anything,
if the list was obtained thru ISPF 3.4 option, all is needed is to save the dataset list
( see ISPF manuals or the online help )
Back to top
View user's profile Send private message
Anuj Dhawan

Superior Member


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

PostPosted: Mon Aug 24, 2009 7:25 pm
Reply with quote

There are two steps involved.

First, as Enrico said and I believe that's the best option per the information in hand or just as an other alternative you may use
Code:
LISTCAT LVL(HLQ) ALL
with IDCAMS.

Second, get that list "downloaded" to PC (in notepad) and "open with" excel.
Back to top
View user's profile Send private message
Bill Dennis

Active Member


Joined: 17 Aug 2007
Posts: 562
Location: Iowa, USA

PostPosted: Tue Aug 25, 2009 2:19 am
Reply with quote

The LISTCAT ALL will generate a lot of extra lines. If you use
Code:
LISTCAT LVL(hlq) NAME
you will get fewer extra lines.
Back to top
View user's profile Send private message
Anuj Dhawan

Superior Member


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

PostPosted: Tue Aug 25, 2009 2:46 pm
Reply with quote

I agree with Bill -- but such ambiguous requests deserve such answers. There is other, probably a neat solution (though depends what one wants) is:
Code:
//STEP01  EXEC PGM=IKJEFT1A                       
//SYSPROC   DD DSN=SYS1.SAMPLIB,DISP=SHR         
//SYSTSPRT  DD DSN=XXXXXX.LIST.HLQ,               
//             DISP=(NEW,CATLG,CATLG),           
//             UNIT=??,SPACE=??,
//             DCB=(RECFM=FB,LRECL=133,BLKSIZE=0)
//SYSTSIN   DD *                                 
%IGGCSIRX                                         
HLQ.**                                           
/*                                               
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts FINDREP - Only first record from give... DFSORT/ICETOOL 3
No new posts Map Vols and Problem Dataset All Other Mainframe Topics 2
No new posts Allocated cylinders of a dataset DB2 12
No new posts Sort First/last record of a subset th... DFSORT/ICETOOL 7
No new posts Reading dataset in Python - New Line ... All Other Mainframe Topics 22
Search our Forums:

Back to Top