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 get list of PDS member names not in PS file

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

Active User


Joined: 26 Nov 2008
Posts: 125
Location: chennai

PostPosted: Fri Jan 08, 2010 12:43 pm    Post subject: how to get list of PDS member names not in PS file
Reply with quote

how to get list of member names of pds which are not present in ps file

I have a pds with 10000 jcls

ex :

AFA1C
AFA10C
AFA12C
AFA16C
----
----
----


and i have ps file like below

Code:
********************************* Top of Data **********************************
F AU151                           800              18      001NE012%004EQNB%006E
F AU151                           800              18      001EQ019%003EQ060%004
F AIU272                          800              08      001EQ019%004EQNB%006E
F AU12866C                        800              01      004EQNB%001EQ010%003E
F AU12866                         800              21      004EQNB%001EQ010%003E
F AFA48C                          800              01      001EQ010%003EQ027%004
F AFA48                           800              21      001EQ010%003EQ027%004
F AU12883C                        800              01      001EO010;016%003EQ010
F AU12883C                        800              01      001EQ010%003EQ010%004
F AU12883C                        800              01      001EQ016%003EQ010%004
F AU12883                         800              21      001EO010;016%003EQ010
F AU12883                         800              21      001EQ010%003EQ010%004

-----
-----

-----

I want the list of the member names of PDS which are not present in the PS file at 3 - 11 positions, if its possible please give me the jcl.

thx
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: Fri Jan 08, 2010 12:51 pm    Post subject:
Reply with quote

Please DO NOT ask for code without showing any effort of your own. As you should be aware by now, this is a HELP forum and not a DO MY JOB FOR ME forum.

You have posted this in the JCL forum without any mention of the program or utility you want to use. Are you one of those misguided people who believe that JCL is the all powerful entity that resolves all merely by using JCL.

Please post what you have tried so far with error messages / codes as appropriate, of if you have not managed to get that far, then explain your proposed logic for doing this task.
Back to top
View user's profile Send private message
nkothako

Active User


Joined: 26 Nov 2008
Posts: 125
Location: chennai

PostPosted: Fri Jan 08, 2010 2:32 pm    Post subject: how to get list of PDS member names not in PS file
Reply with quote

using 3.14 option with BATCH MODE option i am trying to fullfil my requirement like below

Code:
//SEARCH  EXEC PGM=ISRSUPC,PARM=(SRCHCMP,'ANYC')
//NEWDD  DD DSN=R9VJAYA.SORTED.TBLS,
//          DISP=SHR
//OUTDD  DD SYSOUT=(A)
//SYSIN  DD *
SRCHFOR  'AFA1C'
SRCHFOR  'AFA10C'
SRCHFOR  'AFA12C'
SRCHFOR  'AFA16C'
SRCHFOR  'AFA17C'
SRCHFOR  'AFA18C'
SRCHFOR  'AFA2C'
SRCHFOR  'AFA20C'
SRCHFOR  'AFA21C'
---
---
---
/*


but i am looking for unmatched "names" and at specified position( 3 -8) in my PS file
[/code]
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: Fri Jan 08, 2010 3:10 pm    Post subject:
Reply with quote

First, I think that I would use IEHLIST to get a list of the members in the PDS.

Then there is the PS dataset.

Using ICETOOL to read and reformat both sets of records, and then using either SPLICE or SELECT to get the desired results. There are so many good examples of SPLICE or SELECT on the forum.

One simple batch job and the results are yours.
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 SORTJOIN - Copy Matched and Unmatched... Steve Ironmonger DFSORT/ICETOOL 5 Tue Jan 17, 2017 4:26 pm
No new posts Copy RECFM =VB TO FB file with RECL =... sahil41352 DFSORT/ICETOOL 3 Wed Dec 28, 2016 11:29 pm
No new posts find particular member name in PDS us... ravi243 CLIST & REXX 10 Mon Dec 19, 2016 6:44 pm
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 Add PD field from 2nd file to PD in 1st Sushant Garje DFSORT/ICETOOL 6 Thu Dec 01, 2016 4:32 pm


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