|
View previous topic :: View next topic
|
| Author |
Message |
mbala2k4
New User
Joined: 20 Apr 2006
Posts: 2
|
|
|
|
Hi
I have one vsam file with the fields empno,empname,salary.
where as empno is the key field.now i want display the top ten salaried persons empno,empname,salary from that vsam file . how to do that?
i think now u all get the need for sorting the vsam files |
|
| Back to top |
|
 |
sril.krishy
Active User
Joined: 30 Jul 2005
Posts: 183
Location: hyderabad
|
|
|
|
Hi,
What you need to do is sort the VSAM file on SALARY field in decending order and then use the STARTREC command to get the filrst 10 records.
Thanks
Krishy |
|
| Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA
|
|
|
|
What is the position, length and format of the empno field?
What is the position, length and format of the empname field?
What is the position, length and format of the salary field? |
|
| Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA
|
|
|
|
| Quote: |
| then use the STARTREC command to get the filrst 10 records. |
That would be ENDREC, not STARTREC. |
|
| Back to top |
|
|
sril.krishy
Active User
Joined: 30 Jul 2005
Posts: 183
Location: hyderabad
|
|
|
|
Thank you Frank for correcting me.
Thank you
Kirshy |
|
| Back to top |
|
|
|
|
