FTP all member names of modules in a PDS

S0C7 · New User Joined: 19 May 2006 Posts: 26

Hi,

I have lots of modules in a PDS and I need to get all of the member names in that PDS out on an excel sheet. I need just the module names and thats it.

Any ideas on how I can get this quickly without manually copy pasting each item on my sheet?

Thanks

dick scherrer · Posted: Fri Jan 30, 2009 11:50 am

Hello,

By whatever means you prefer, create a list of member names - writing the list to a disk file rather than the screen or a sysout. Edit the file to discard any unneeded info.

FTP the file from the mainframe to your desktop system. Import the file into excel and then you have the members in a spreadsheet.

S0C7 · New User Joined: 19 May 2006 Posts: 26

dick scherrer · Posted: Fri Jan 30, 2009 12:07 pm

Hello,

Look here:
ibmmainframes.com/viewtopic.php?t=235

You should be able to use the listds or listdsi and the jcl posted in that topic.

kranthikumarb · Posted: Fri Feb 06, 2009 5:04 pm

Hi SOC7

,

Open the dataset and give the following command.
"Save <2nd level qualifier>"

All the members along with their attributes will be copied into a member.
The member name would be

<your user id>.<2nd lever qualifier>.members

I think now you can FTP into an EXCEL sheet.

Hope this helps.

Robert Sample · Posted: Fri Feb 06, 2009 5:09 pm

FTP from your PC to the mainframe, piping output to a file. Sign on as usual. Issue the FTP commands: