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
 

 

members of a pds into excel
Goto page 1, 2  Next
 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
shchan

New User


Joined: 06 Jun 2007
Posts: 58
Location: Hyderabad

PostPosted: Wed Mar 11, 2009 12:44 pm    Post subject: members of a pds into excel
Reply with quote

Hi ,
Is there any command to copy the names of the members in a PDS to an excel or a ps file atleast ??
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: Wed Mar 11, 2009 12:52 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
shchan

New User


Joined: 06 Jun 2007
Posts: 58
Location: Hyderabad

PostPosted: Wed Mar 11, 2009 12:57 pm    Post subject:
Reply with quote

Thanks expat,
can u please tell me how to use this command because i tried using it 'tso iehlist' but it did not work.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Wed Mar 11, 2009 1:15 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
krisprems

Active Member


Joined: 27 Nov 2006
Posts: 649
Location: India

PostPosted: Wed Mar 11, 2009 1:17 pm    Post subject:
Reply with quote

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

SAVE <NAME1>

and you will see the member names saved in USERID.<NAME1>.MEMBERS
Back to top
View user's profile Send private message
krisprems

Active Member


Joined: 27 Nov 2006
Posts: 649
Location: India

PostPosted: Wed Mar 11, 2009 1:19 pm    Post subject:
Reply with quote

dick scherrer

You were a bit quicker than me icon_cool.gif
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Wed Mar 11, 2009 1:29 pm    Post subject: Reply to: members of a pds into excel
Reply with quote

Only just a little bit. . . icon_cool.gif

d
Back to top
View user's profile Send private message
shchan

New User


Joined: 06 Jun 2007
Posts: 58
Location: Hyderabad

PostPosted: Wed Mar 11, 2009 1:44 pm    Post subject:
Reply with quote

Thanks a lot dick scherrer and krisprems for your replies.
Back to top
View user's profile Send private message
cardnut

New User


Joined: 15 Jan 2008
Posts: 15
Location: USA, St Louis, Missouri

PostPosted: Mon Oct 19, 2009 11:23 pm    Post subject: Reply to: members of a pds into excel
Reply with quote

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.
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 7909
Location: Bellevue, IA

PostPosted: Mon Oct 19, 2009 11:43 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
MBabu

Active User


Joined: 03 Aug 2008
Posts: 401
Location: Mumbai

PostPosted: Mon Oct 19, 2009 11:59 pm    Post subject: Re: Reply to: members of a pds into excel
Reply with quote

cardnut wrote:
*Been doing JCL for over 25 years and right now I just feel really dumb.
Welcome to my world icon_smile.gif
Back to top
View user's profile Send private message
cardnut

New User


Joined: 15 Jan 2008
Posts: 15
Location: USA, St Louis, Missouri

PostPosted: Tue Oct 20, 2009 12:00 am    Post subject:
Reply with quote

well at least we are not alone. icon_lol.gif
Back to top
View user's profile Send private message
cardnut

New User


Joined: 15 Jan 2008
Posts: 15
Location: USA, St Louis, Missouri

PostPosted: Tue Oct 20, 2009 12:26 am    Post subject:
Reply with quote

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!!
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: Tue Oct 20, 2009 12:30 am    Post subject: Reply to: members of a pds into excel
Reply with quote

What's wrong with using good ol' TSO LISTDS?
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 7909
Location: Bellevue, IA

PostPosted: Tue Oct 20, 2009 12:31 am    Post subject:
Reply with quote

This is what I ran:
Code:
 000002 //STEP1    EXEC PGM=IEHLIST,REGION=0M
 000003 //SYSPRINT DD  SYSOUT=*
 000004 //DD2      DD  DISP=SHR,DSN=TTSSRS0.JCL.CNTL
 000005 //SYSIN    DD  *
 000006       LISTPDS   DSNAME=(TTSSRS0.JCL.CNTL),VOL=SYSDA=PGMRS1,DUMP
 000007 /*
and the left part of the output starts
Code:
1                              SYSTEMS SUPPORT UTILITIES---IEHLIST
-DATE: 2009.292  TIME: 14.59.58
  DIRECTORY INFO FOR SPECIFIED PDS ON VOL PGMRS1
 TTSSRS0.JCL.CNTL
0           MEMBERS     TTRC     VARIABLE USER DATA ---(USER DATA AND TTRC ARE I
           $AVRGPRT  013B030F  0100000401 09271F0109 271F134800 1300130000 E3E3E
           $AVRPRNT  0063080F  0300000501 05215F0105 215F111200 2100210000 E3E3E
           $INST2    0030070F  0300000501 05215F0105 215F111200 8A008A0000 E3E3E
           AACOPY    00B2050F  0100001901 06305F0106 305F112300 0B000B0000 E3E3E
           AATEST    00B20F0F  0103002301 06250F0106 310F154300 0E00070008 E3E3E
           ABENDTST  01261C0F  0308005901 05215F0109 181F150200 0D000A0000 E3E3E
           ABTSTCMP  009F070F  0100005601 06039F0106 039F113800 2C002C0000 E3E3E
Back to top
View user's profile Send private message
cardnut

New User


Joined: 15 Jan 2008
Posts: 15
Location: USA, St Louis, Missouri

PostPosted: Tue Oct 20, 2009 12:33 am    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
cardnut

New User


Joined: 15 Jan 2008
Posts: 15
Location: USA, St Louis, Missouri

PostPosted: Tue Oct 20, 2009 12:40 am    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 7909
Location: Bellevue, IA

PostPosted: Tue Oct 20, 2009 12:42 am    Post subject:
Reply with quote

Glad to hear it worked -- hope the rest of it goes smoother (maybe start on Tuesday instead of Monday?) icon_smile.gif
Back to top
View user's profile Send private message
cardnut

New User


Joined: 15 Jan 2008
Posts: 15
Location: USA, St Louis, Missouri

PostPosted: Tue Oct 20, 2009 12:47 am    Post subject:
Reply with quote

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.)
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 7909
Location: Bellevue, IA

PostPosted: Tue Oct 20, 2009 1:16 am    Post subject:
Reply with quote

Maybe I should send some Varsity your way? Zesto's is the correct spelling, by the way.
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
Goto page 1, 2  Next
Page 1 of 2

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Single step utility for compare and u... ramprakashn JCL & VSAM 5 Fri Apr 29, 2016 3:43 pm
No new posts How to read a excel sheet and load it... Radhika Nambiar Java & MQSeries 10 Wed Mar 30, 2016 4:49 pm
No new posts Differences between copying members b... E.LAI TSO/ISPF 8 Wed Mar 30, 2016 12:35 pm
No new posts Formatting data from Excel to mainframe kishpra JCL & VSAM 5 Fri Feb 19, 2016 7:12 pm
No new posts Empty excel attachment in mail receiv... gs185008 COBOL Programming 8 Mon Jul 13, 2015 7:45 pm


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