MVSFORUMS.com

tictac · Posted: Thu May 05, 2005 5:50 am Post subject: Sorting VSAM Records

hello sirs and madams,
supposed i have vsam records that has the elements:

kolusu · Posted: Thu May 05, 2005 5:59 am Post subject:

tictac,

s_shivaraj · Posted: Thu May 05, 2005 6:02 am Post subject:

tictac,

You need to post the record keys position in the file also.. There are lot of posts available for sorting, you can search that and modify according to your need..
_________________
Cheers
Sivaraj S

'Technical Skill is the Master of complexity, while Creativity is the Master of Simplicity'

tictac · Posted: Thu May 05, 2005 9:48 pm Post subject:

hi kolusu and sivaraj!
thanks for your reply... should i include this in the JCL that defines the VSAM file? also when i insert a record in the file, will this record be placed in the correct location based on the B-DAY?

thanks again! Very Happy

Phantom · Posted: Fri May 06, 2005 7:39 am Post subject:

Tictac,

I think you are confused. The VSAM file will always be in ascending order of the key field. All you can do is to temporarily sort the data in a different order and store it in ANOTHER dataset and use that dataset in your program as input instead of the original VSAM file.

Let us know if you have any questions,

Thanks,
Phantom

tictac · Posted: Sun May 08, 2005 9:20 pm Post subject: is alternate index an option???

Phantom · Posted: Mon May 09, 2005 5:21 am Post subject:

Tictac,

yes, Alternate Index would also be a better option for you. Just create an alternate index on the DOB column (field) and use the alternate index cluster as input to your program. This will provide you the flexibility of using RANDOM READ though the data is not stored in strict ascending order of DOB. No need to sort the file on DOB now.

Let us know if you face any problems,

Thanks,
Phantom