| View previous topic :: View next topic |
| Author |
Message |
ranga_subham
Intermediate
Joined: 31 Jan 2006
Posts: 255
Topics: 72
|
 Posted: Sat Sep 20, 2008 9:43 am Post subject: Find members for not equal condition. |
 |
|
Hi,
As part of DB2 V8 upgrade we promoted few packages with DSNEXIT added to our PROD JCLs. But, we feel like few members may be still missing this change.
My requirement is to find all the PDS members that DO NOT have either DSNLOAD / DSNEXIT in them.
Would you please tell me how to do this?
Thanks.
_________________
Ranga
*****
None of us is as smart as all of us - Ken Blanchard |
|
| Back to top |
|
 |
Dibakar
Advanced
Joined: 02 Dec 2002
Posts: 700
Topics: 63
Location: USA
|
|
| Back to top |
|
|
ranga_subham
Intermediate
Joined: 31 Jan 2006
Posts: 255
Topics: 72
|
| Posted: Mon Sep 22, 2008 4:57 am Post subject: |
|
|
Dibakar, I don't know REXX. Would you tell me any other way of it?
Thanks.
_________________
Ranga
*****
None of us is as smart as all of us - Ken Blanchard |
|
| Back to top |
|
|
hchinnam
Beginner
Joined: 04 Feb 2005
Posts: 31
Topics: 10
|
| Posted: Mon Sep 22, 2008 10:04 am Post subject: |
|
|
Simplest way I can think of is,
Open the pds, and issue SRCHFOR 'dsnexit'. It will display all '*Found' against all the members that have this text.
Sort the pds member list based on prompt and you have your list.
Things get a little complicated if you want to find both the strings. You have to do the same process differently and take the common members in to account. |
|
| Back to top |
|
|
expat
Intermediate
Joined: 01 Mar 2007
Posts: 475
Topics: 9
Location: Welsh Wales
|
| Posted: Tue Sep 23, 2008 1:07 am Post subject: |
|
|
| ranga_subham wrote: | Dibakar, I don't know REXX. Would you tell me any other way of it?
Thanks. |
If you take a good look at the REXX EXEC supplied, it is obvious that you do not need to be a rocket scientist to make a couple of simple changes to do exactly what you want it to do.
I'll even give you a clue, as the RC is 4 for a string not found condition is 4, then you only want to display (SAY) those members where Rcx + Rcy = 8.
_________________
If it's true that we are here to help others,
then what exactly are the others here for ? |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
