Page 1 of 1

Can we convert ESDS to KSDS?

PostPosted: Thu Jan 31, 2013 2:18 pm
by ramya_MF
Can we convert ESDS to KSDS?

Re: Can we convert ESDS to KSDS?

PostPosted: Thu Jan 31, 2013 2:26 pm
by enrico-sorichetti
it depends! :mrgreen:

look at the manuals to understand ESDS vs. KSDS
for the KEY definition constraints

Re: Can we convert ESDS to KSDS?

PostPosted: Thu Jan 31, 2013 5:15 pm
by steve-myers
It depends. You simply have not told us whether you want to do this in place, without copying the data, or if you can copy the ESDS data set to a KSDS data set.
  • In place - NO. Period. Full stop. End of story.
  • By copying - You must allocate the KSDS after determining the location and size of the key. Once you have done this, you can use the REPRO command in IDCAMS to create the data in the KSDS. If the REPRO fails, most likely you have specified the key in the KSDS incorrectly, and you will have to start over. If the key is correct, the ESDS is not sorted in key order, so you will have to start over, sort the ESDS, and then do the copy.

Re: Can we convert ESDS to KSDS?

PostPosted: Fri Feb 01, 2013 11:58 am
by ramya_MF
Thank a lot Folks,

It's working.