View previous topic :: View next topic |
Author |
Message |
gotluru Beginner
Joined: 17 Dec 2002 Posts: 29 Topics: 6
|
Posted: Fri Feb 07, 2003 3:36 pm Post subject: Searching 2 fields in a member of a PDS and regular search |
|
|
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')
Code: |
000006 //SEARCH EXEC PGM=ISRSUPC,
000007 // PARM=(SRCHCMP,
000008 // 'ANYC','ANYC'),
000009 // TIME=NOLIMIT
000010 // INCLUDE MEMBER=SLODLIB&AENV
000011 //NEWDD DD DSN=DOTPAG.COBOL.CNTL,
000012 // DISP=SHR
000013 //OUTDD DD SYSOUT=*
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 /*
|
Thanks,
Prasad |
|
Back to top |
|
|
kolusu Site Admin
Joined: 26 Nov 2002 Posts: 12372 Topics: 75 Location: San Jose
|
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 |
|
Back to top |
|
|
gotluru Beginner
Joined: 17 Dec 2002 Posts: 29 Topics: 6
|
Posted: Fri Feb 07, 2003 5:18 pm Post subject: |
|
|
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 |
|
Back to top |
|
|
gotluru Beginner
Joined: 17 Dec 2002 Posts: 29 Topics: 6
|
Posted: Mon Feb 10, 2003 10:11 am Post subject: |
|
|
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 |
|
Back to top |
|
|
coolman Intermediate
Joined: 03 Jan 2003 Posts: 283 Topics: 27 Location: US
|
Posted: Thu Feb 13, 2003 2:35 am Post subject: |
|
|
Gotluru,
Can you explain the scenario more elaborately...
Quote: |
I need members 'DT_PPROJ_LOC' AND 'BRDG_ID' any where in the program.
|
I lost your requirement at this point. If you could elaborate it on more specific lines, we can help you.
Suggestion :
Give a Sample Example of a PDS with members(5) with what do you want and say how do you want the output to be ?? That would bridge the communication gap that happens so often in our forums...
Cheers,
Coolman.
________
B platform
Last edited by coolman on Sat Feb 05, 2011 1:17 am; edited 1 time in total |
|
Back to top |
|
|
gotluru Beginner
Joined: 17 Dec 2002 Posts: 29 Topics: 6
|
Posted: Tue Feb 18, 2003 9:59 am Post subject: |
|
|
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 |
|
Back to top |
|
|
|
|