Using EZtrieve to insert a record in a KSDS VSAM file

rashmi123 · New User Joined: 04 Jun 2007 Posts: 25 Location: Pune

I am using EZtrieve to insert a record in a KSDS VSAM file. The new record which I am inserting is apperaing at the end. I want it to appear at the position based on the key value. How can this be done in EZtrieve?
The key comprises of the following:
WS-FIL-NUM1 1 3 P
WS-FIL-NUM2 4 3 P
WS-FIL-NUM3 7 10 P
WS-FIL-NUM4 17 3 P

William Thompson · Posted: Tue Jun 05, 2007 2:38 pm

rashmi123 · New User Joined: 04 Jun 2007 Posts: 25 Location: Pune

I am using File Master to view the VSAM file

William Thompson · Posted: Tue Jun 05, 2007 4:55 pm

I guess you may need to tell File Master that it is a keyed file and you want to see the records in key order.

dick scherrer · Posted: Tue Jun 05, 2007 5:50 pm

Hello,

Keep in mind that the physical record is not shoved into the middle of the file by key when you write/add a new record.

expat · Posted: Tue Jun 05, 2007 5:59 pm

William Thompson · Posted: Tue Jun 05, 2007 6:03 pm

I have to disagree also.....
The only way I can see this happening is the new record is somehow in a different CI/CA?

dick scherrer · Posted: Tue Jun 05, 2007 7:18 pm

Hello,

I'm not sure of all of the rules, but i believe that while keys are managed in "real time", not always the data. I may continue being mistaken, but i seem to recall that a dasd dump of some vsam files showed data records that were not stored in physical sequential order by key. When the key was used, the records were read in the correct sequence, but until a reorg or until vsam "caught up", they were stored out of order.

Again, i may well be mis-remembering - been more than just a little while and i have surrendered to losing things that are little used currently. . .

If the folks that use vsam a lot currently say it won't happen, i'll go with them