members of a pds into excel

shchan · New User Joined: 06 Jun 2007 Posts: 58 Location: Hyderabad

Hi ,
Is there any command to copy the names of the members in a PDS to an excel or a ps file atleast ??

expat · Posted: Wed Mar 11, 2009 12:52 pm

Yes, and the various ways of doing this via REXX are all mentioned on the forum, and you can also use utilies like IEHLIST if you are unsure about REXX.

shchan · New User Joined: 06 Jun 2007 Posts: 58 Location: Hyderabad

Thanks expat,
can u please tell me how to use this command because i tried using it 'tso iehlist' but it did not work.

dick scherrer · Posted: Wed Mar 11, 2009 1:15 pm

Hello,

In tso/ispf generate a member list.

In the command area, enter SAVE your.pdslist.

A dataset "userid.your.pdslist.members" will be created with what you want.

This member list could then be downloaded to the ps and imported into excel.

krisprems · Posted: Wed Mar 11, 2009 1:17 pm

shchan
Just open the PDS and in the command line mention the following command

krisprems · Posted: Wed Mar 11, 2009 1:19 pm

dick scherrer

You were a bit quicker than me

dick scherrer · Posted: Wed Mar 11, 2009 1:29 pm

Only just a little bit. . .

d

shchan · New User Joined: 06 Jun 2007 Posts: 58 Location: Hyderabad

Thanks a lot dick scherrer and krisprems for your replies.

cardnut · Posted: Mon Oct 19, 2009 11:23 pm

I am trying to do the same thing, but I need to use a batch job for it. I have tried running IEHLIST, but it keeps asking for a volume ID and the JCL book I have does not really explain it.

I am trying to run members lists of Changeman files (our migration tool) so I can compare and see if we have similiar members in different packages.

*Been doing JCL for over 25 years and right now I just feel really dumb.

Robert Sample · Posted: Mon Oct 19, 2009 11:43 pm

The syntax is <LABEL> LISTPDS DSNAME=??,VOL=<DEVTYPE>=<VOLSER>,DUMP where the device type and volume serial will be site specific (such as VOL=SYSDA=ABC001). If you don't use a label, you'll still need a space before the LISTPDS command -- standard utility command format.

MBabu · Posted: Mon Oct 19, 2009 11:59 pm

cardnut · Posted: Tue Oct 20, 2009 12:00 am

well at least we are not alone.

cardnut · Posted: Tue Oct 20, 2009 12:26 am

Robert - I have tried several ways to get it to run. Even checked with my storage guy to make sure the device type was right. It still does not want to run.

Could PDSMAN do something for what I need?

MBabu, I feel really, really dumb. and I am the tech guy that my developers come to!!

superk · Posted: Tue Oct 20, 2009 12:30 am

What's wrong with using good ol' TSO LISTDS?

Robert Sample · Posted: Tue Oct 20, 2009 12:31 am

This is what I ran:

cardnut · Posted: Tue Oct 20, 2009 12:33 am

That does fine for me to see what is there, but my problem is that I need to make this an automated process. My boss does not want it to be counting on one person to do it. Something we could schedule to run daily or weekly.

cardnut · Posted: Tue Oct 20, 2009 12:40 am

Robert, I stand corrected.

Man, I hate Mondays. Brain just does not want to work. Must not have had enough coffee today.

I ran that and it worked. Thanks.

Robert Sample · Posted: Tue Oct 20, 2009 12:42 am

Glad to hear it worked -- hope the rest of it goes smoother (maybe start on Tuesday instead of Monday?)

cardnut · Posted: Tue Oct 20, 2009 12:47 am

Well since I just put NEW,DELETE,KEEP in trying to create a new file, I hope tomorrow is better.

I know what I need!!

ZESTOS!! (And if I spelled it wrong, I can say it cause I am from NY and only visited Atlanta.)

Robert Sample · Posted: Tue Oct 20, 2009 1:16 am

Maybe I should send some Varsity your way? Zesto's is the correct spelling, by the way.

cardnut · Posted: Tue Oct 20, 2009 1:18 am

Now Varsity would be nice too. Always a great meal there. First time I went there almost got run over cuase I took too long to decide on what I wanted.

dick scherrer · Posted: Tue Oct 20, 2009 1:18 am

Hello,

gcicchet · Posted: Tue Oct 20, 2009 3:54 am

Hi,

the only issue with IEHLIST is you need to know the volume the dataset resides on, and when the dataset is moved to a different volume, the job will fail.

So I'm with Kevin on this, less maintenance

cardnut · Posted: Tue Oct 20, 2009 4:05 am

gcicchet,

Thanks. With this and the IEHLIST, I can give my boss a choice of what he wants to see. He still has not fully explained what he is looking for or how it will help me with release management.

thanks again.

Terry Heinze · Posted: Tue Oct 20, 2009 7:01 am