|
View previous topic :: View next topic
|
| Author |
Message |
nkothako
Active User
Joined: 26 Nov 2008
Posts: 125
Location: chennai
|
|
|
|
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 |
|
 |
expat
Global Moderator
Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales
|
|
|
|
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 |
|
|
nkothako
Active User
Joined: 26 Nov 2008
Posts: 125
Location: chennai
|
|
|
|
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 |
|
|
expat
Global Moderator
Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales
|
|
|
|
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 |
|
|
|
|
