Records inserted in KSDS is not in sorted order

raviprabhu · New User Joined: 20 Oct 2006 Posts: 29

Hi,

I have written a program to read from flat file and write to KSDS file and I see the records in KSDS file is not in sorted order.
Any reason for this ?

Regards,
Ravi

Akatsukami · Posted: Thu Jan 02, 2014 9:39 pm

Why would you expect them to be? They are accessed through the index.

raviprabhu · New User Joined: 20 Oct 2006 Posts: 29

I want the records in KSDS to be in sorted order.

After writing every record it should be in sorted order

Bill Woodger · Posted: Thu Jan 02, 2014 9:57 pm

The records on a KSDS are in the order established by the primary key.

If they are not, then you are not looking at the primary key, or you are not looking at a KSDS.

Any other data outside the primary key is irrelevant to the order of the records.

This doesn't relate to your earlier questions does it?

Akatsukami · Posted: Thu Jan 02, 2014 9:57 pm

What do you intend to do that requires the data to be in a certain order?

Bill O'Boyle · Posted: Thu Jan 02, 2014 10:22 pm

To guarantee a proper sorted-order, SORT the flat file by the designated primary-key (which you have defined in the VSAM Base Cluster), then REPRO directly into the KSDS.

Is this an option?

raviprabhu · New User Joined: 20 Oct 2006 Posts: 29

The records in flat file is as below

Key length is 65

dick scherrer · Posted: Thu Jan 02, 2014 10:23 pm

Hello,

Bill O'Boyle · Posted: Thu Jan 02, 2014 10:27 pm

What's the record-position in the flat-file where the primary-key can be found? This is the sorted order you need and invoking SORT to sort these records, allows you to REPRO the records directly into the VSAM KSDS in the proper order.

Am I missing something?

Terry Heinze · Posted: Thu Jan 02, 2014 10:40 pm

Please use Code tags when posting your records and show us the IDCAMS listcat showing the Relative Key Position (RKP) and key length. Remember that the RKP is relative to zero, not one.

raviprabhu · New User Joined: 20 Oct 2006 Posts: 29

Ok let me ask this way..

After writing records to KSDS file does the records will be in sorted order ?

dick scherrer · Posted: Thu Jan 02, 2014 11:20 pm

Hello,

Not if you do not sort them before writing/loading them into the file.

dick scherrer · Posted: Thu Jan 02, 2014 11:21 pm

Addon . . .

You still have not explained WHY you think this is needed . . .

Bill Woodger · Posted: Thu Jan 02, 2014 11:26 pm

It is a KSDS. It will be in primary key order. It is always best when adding records to a KSDS to have them sorted in key order, but it will make no difference.

A KSDS, assuming successfully written, will be in key order, no matter the order of the input.

You must show a LISTCAT for your (alleged) KSDS.

It is beginning to smell of Troll.

dick scherrer · Posted: Fri Jan 03, 2014 1:18 am

Hi Bill,

Ed Goodman · Active Member Joined: 08 Jun 2011 Posts: 556 Location: USA

raviprabhu,

Somewhere, there is a 'DEFINE' for that KSDS to which you are writing. In that DEFINE, there is a KEYS parameter.

Can you tell us what that KEYS parameter looks like?

I'm asking because when you load a KSDS, the records will get sorted based on the contents of the record that is pointed to by the KEYS parameter.

It sounds a lot like you have two different definitions of the 'key' for this file. One is your SORT key, and one is your KSDS key.