MVSFORUMS.com

gotluru · Beginner Joined: 17 Dec 2002 Posts: 29 Topics: 6

Hi All,
I am searching for few fields. I need members if 2 fields are matched(ex: SRCHFOR 'DT_PPROJ_LOC' AND 'BRDG_ID') and members for 1 field match (ex: SRCHFOR 'PPROJ_RTE_TY_CD')

kolusu · Posted: Fri Feb 07, 2003 3:41 pm Post subject:

Gotluru,

Do you want members that have 'DT_PPROJ_LOC' AND 'BRDG_ID on the same line??

Do you want a seperate report for 'PPROJ_RTE_TY_CD' ?

You need to be more specific.

Thanks

kolusu

gotluru · Beginner Joined: 17 Dec 2002 Posts: 29 Topics: 6

Hi Kolusu,

Thanks for your immediate response.

No, I need members 'DT_PPROJ_LOC' AND 'BRDG_ID' any where in the program.
and need members with other fields also.

What's happening is if i search for individual field for ex: BRDG_ID is having in all the pds members with other table name's and most of the program ,we did't used table name and column name in the same line. So, to limit a search i am looking for Table and Field Name.

if i run this jcl;
000014 //SYSIN DD *
000015 SRCHFOR 'PPROJ_RTE_TY_CD'
000016 SRCHFOR 'PPROJ_RTE_NM_TXT'
000017 SRCHFOR 'PPROJ_RTE_MILE_PT'
000018 SRCHFOR 'DT_PPROJ_LOC' AND 'BRDG_ID'
000019 SRCHFOR 'DT_PPROJ_LOC' AND 'PPROJ_ID'
000020 /*

my output is:
THE FOLLOWING PROCESS STATEMENTS (USING COLUMNS 1:72) WERE PROCESSED:
SRCHFOR 'PPROJ_RTE_TY_CD'
SRCHFOR 'PPROJ_RTE_NM_TXT'
SRCHFOR 'PPROJ_RTE_MILE_PT'
SRCHFOR 'DT_PPROJ_LOC' AND 'BRDG_ID'
ISRS024W EXTRA DATA DETECTED AFTER NORMAL STATEMENT END. STATEMENT ACCEPTED WITH WARNING NOTIFICATION.
SRCHFOR 'DT_PPROJ_LOC' AND 'PPROJ_ID'
ISRS024W EXTRA DATA DETECTED AFTER NORMAL STATEMENT END. STATEMENT ACCEPTED WITH WARNING NOTIFICATION.

If i did't explain well, please ask me again.
Thanks,
Prasad

gotluru · Beginner Joined: 17 Dec 2002 Posts: 29 Topics: 6

Hi Ravi,

Thanks for your response.

How I am going to know members?
Do you want me to go through the scan report and hard code members OR Any other method is there to get from the previous step run? I am expecting 100's of members in my scan report..

Thanks,
Prasad

coolman · Posted: Thu Feb 13, 2003 2:35 am Post subject:

Gotluru,
Can you explain the scenario more elaborately...

gotluru · Beginner Joined: 17 Dec 2002 Posts: 29 Topics: 6

Hi Coolman/Ravi,

Sorry for late reply.

Ravi:
Thanks for your solution.

Coolman:
I am looking for 2 fields like: Table Name and Column Name in this case table name is dt_pproj_loc and column name is brdg_id. The same column is used in differant tables. When i search for these 2 fields i am getting all other pds members even one selection critiare matches. Ravi's solution works, but program names has to copy from output file. If you have any easy solution. I will appreciate it.

Thanks,
Prasad