| View previous topic :: View next topic |
| Author |
Message |
krkcs
Beginner
Joined: 30 May 2004
Posts: 27
Topics: 5
|
 Posted: Tue Oct 11, 2005 5:16 am Post subject: |
 |
|
Perfect Phantom....Thanks a Lot...!!!
_________________
-kr |
|
| Back to top |
|
 |
krkcs
Beginner
Joined: 30 May 2004
Posts: 27
Topics: 5
|
| Posted: Fri Oct 14, 2005 12:46 am Post subject: |
|
|
Phantom,
What if, If I need only first occurences of the "REF" or "STD" ?? Now we will get only the first occurences of "REF", but requirement is changed now. sorry for this.
I need only first occurence of "REF" or "STD".
Input:
| Code: |
----+----1----+----2
AABHYSTDPERE
BAMQHSTDPERE
BAMQHREFOPER
BAMQHREFUPER
BAMQHSTDPERE
BBCBKREFUPER
BBCBKREFUPEF
BBCBKSTDUPEF
BBCBZREFFERE
BBCBZREFR342
|
Output:
| Code: |
----+----1----+----2
AABHYSTDPERE
BAMQHSTDPERE
BBCBKREFUPER
|
_________________
-kr |
|
| Back to top |
|
|
Phantom
Data Mgmt Moderator
Joined: 07 Jan 2003
Posts: 1056
Topics: 91
Location: The Blue Planet
|
| Posted: Fri Oct 14, 2005 1:08 am Post subject: |
|
|
krkcs,
Kolusu has already given the answer for this... This requirement is very simple, Just use SUM FIELDS=NONE !!!. Look at 10th post from Bottom (by Kolusu).
Thanks,
Phantom |
|
| Back to top |
|
|
krkcs
Beginner
Joined: 30 May 2004
Posts: 27
Topics: 5
|
| Posted: Fri Oct 14, 2005 1:21 am Post subject: |
|
|
Phantom,
Will sum fields=none get the first occurences alone ?? I have tried but found for some of the records are the second, third and other occurences also....Thanks !
_________________
-kr |
|
| Back to top |
|
|
Phantom
Data Mgmt Moderator
Joined: 07 Jan 2003
Posts: 1056
Topics: 91
Location: The Blue Planet
|
| Posted: Fri Oct 14, 2005 1:38 am Post subject: |
|
|
Krkcs,
| Quote: |
have tried but found for some of the records are the second, third and other occurences also....Thanks !
|
I didn't get you....SORT FIELDS & SUM FIELDS=NONE will get you One occurrence of every key. Are you saying that for some key instead of the first occurrence, you see second / third record. If that is the case, you must use OPTION EQUALS.
One Humble Request. When you try some code and say that it is not working, please post the JCL you used so that we can see if you had missed any statements by mistake / modified something without realising that, that would cause a problem.
Thanks,
Phantom |
|
| Back to top |
|
|
krkcs
Beginner
Joined: 30 May 2004
Posts: 27
Topics: 5
|
| Posted: Fri Oct 14, 2005 1:43 am Post subject: |
|
|
You got me right Phantom..and it's working as I needed....
Going forward will follow your suggestion of posting the JCL also...Thanks for your suggestion...
Thanks !
_________________
-kr |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
