| View previous topic :: View next topic |
| Author |
Message |
tiger_wen
Beginner
Joined: 04 Nov 2005
Posts: 12
Topics: 4
|
 Posted: Mon Nov 07, 2005 12:49 am Post subject: I want to get a TSO procedure to get data from a DS with the |
 |
|
Hi
I want to get a TSO procedure/JCL sample to get data with the same key value from a sorted sequential dataset.
Thanks. |
|
| Back to top |
|
 |
Phantom
Data Mgmt Moderator
Joined: 07 Jan 2003
Posts: 1056
Topics: 91
Location: The Blue Planet
|
| Posted: Mon Nov 07, 2005 2:06 am Post subject: |
|
|
Tiger_Wen,
Please provide complete and clear information whenever you post any query. You are sitting miles away from us and we just can't read whats in your mind.
| Quote: |
to get data with the same key value
|
1. What do you mean by "Same Key Value" - A Duplicate entry ??? (or)
2. Do you have a set of key(s) in another dataset which you want to match against your master file ???
3. What is the LRECL and RECFM of your input file(s) ?
The simplest solution to extract a set of data from an input file is using SORT.
1. If you want to extract all duplicate entries into a separate file then search the UTILITIES forum for the keyword "SELECT AND NODUPS"
2. If you have a set of keys in any file and you want to extract this subset from a master file then you need to go for INCLUDE condition in SORT. Search for "INCLUDE COND=" and you will see tons of posts on that.
Thanks,
Phantom |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
