| View previous topic :: View next topic |
| Author |
Message |
mf_user
Intermediate
Joined: 01 Jun 2003
Posts: 372
Topics: 105
|
 Posted: Mon Jan 05, 2009 9:39 am Post subject: SUBSET option of DFSORT |
 |
|
Hi, Is it necessary to know the RRN number (is it compulsory) if one wants to use the SUBSET feature of ICETOOL?
Please explain.
Thanks.
_________________
MF
==
Any training that does not include the emotions, mind and body is incomplete; knowledge fades without feeling.
== |
|
| Back to top |
|
 |
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12378
Topics: 75
Location: San Jose
|
| Posted: Mon Jan 05, 2009 11:08 am Post subject: |
|
|
mf_user,
NO . It is not mandatory to have RRN. if you want to select based on the record number then you would need it.
The syntax for the SUBSET operator is as follows:
| Code: |
SUBSET FROM(indd) TO(outdd) DISCARD(savedd) KEEP|REMOVE INPUT|OUTPUT
HEADER|FIRST|HEADER(x)|FIRST(x)
RRN(x)|RRN(x,y)|RRN(x,*) ...
TRAILER|LAST|TRAILER(x)|LAST(x)
USING(xxxx) VSAMTYPE(x)
|
For complete details on SUBSET and other new features, read this excellent tutorial
www.ibm.com/systems/support/storage/software/sort/mvs/ugpf/
_________________
Kolusu
www.linkedin.com/in/kolusu |
|
| Back to top |
|
|
mf_user
Intermediate
Joined: 01 Jun 2003
Posts: 372
Topics: 105
|
| Posted: Mon Jan 05, 2009 11:42 am Post subject: |
|
|
Thank you for the details.
_________________
MF
==
Any training that does not include the emotions, mind and body is incomplete; knowledge fades without feeling.
== |
|
| Back to top |
|
|
Frank Yaeger
Sort Forum Moderator
Joined: 02 Dec 2002
Posts: 1618
Topics: 31
Location: San Jose
|
| Posted: Mon Jan 05, 2009 11:45 am Post subject: |
|
|
| Quote: | | Is it necessary to know the RRN number (is it compulsory) if one wants to use the SUBSET feature of ICETOOL? |
With DFSORT's SUBSET, you can keep or remove the first n records, the last n records or specific records identified by their relative record numbers. For complete details, see:
www.ibm.com/systems/support/storage/software/sort/mvs/ugpf/
If you need more help with this, you need to explain in detail what you're trying to do.
_________________
Frank Yaeger - DFSORT Development Team (IBM)
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT is on the Web at:
www.ibm.com/storage/dfsort |
|
| Back to top |
|
|
mf_user
Intermediate
Joined: 01 Jun 2003
Posts: 372
Topics: 105
|
| Posted: Tue Jan 06, 2009 4:12 am Post subject: |
|
|
Frank, there is a huge file and I want to keep specific records identified by their relative record numbers. But, how would I know their RRN?
Thanks.
_________________
MF
==
Any training that does not include the emotions, mind and body is incomplete; knowledge fades without feeling.
== |
|
| Back to top |
|
|
Frank Yaeger
Sort Forum Moderator
Joined: 02 Dec 2002
Posts: 1618
Topics: 31
Location: San Jose
|
| Posted: Tue Jan 06, 2009 11:31 am Post subject: |
|
|
| Quote: | | Frank, there is a huge file and I want to keep specific records identified by their relative record numbers. But, how would I know their RRN? |
Huh? You say you want to keep specific records identified by their relative record numbers - the RRN is the relative record number, so if you know the relative record numbers, you know the RRNs. For example, if you want to keep relative record numbers 10-15, then you use RRN(10,15).
If you don't know the relative record numbers of the records you want, then how exactly do you identify the records you want? What is the "logic" you want to implement programmatically? What are the "rules"?
You need to be more clear about what you're trying to do. An example might help.
_________________
Frank Yaeger - DFSORT Development Team (IBM)
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT is on the Web at:
www.ibm.com/storage/dfsort |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
