On Wed, 30 Aug 2017 15:35:47 -0500, John Mckown (john.archie.mck...@gmail.com) wrote about "dumb VSAM KSDS & AIX question." (in <caajsdjimcsbansqo2xfgmfwsy22yfx8sm1ybznn+xi_zy5o...@mail.gmail.com>):
> A programmer came by with a question. He asked if, when you are reading a > VSAM KSDS via an alternate index (PATH), to have duplicates returned in > base key order. I don't think that is possible. It depends on how much effort you are prepared to put in. VSAM, by itself, will not do it. > From examining the contents > of the AIX records themselves, it appears to me that the base key for a > "new" base record with a given alternate key is just placed at the end of > the keys. Yes, I know, if this sort of thing is a requirement, we need Db2 > (or is it DB2), but that is _never_ going to happen around here. It is DB2. But that isn't really necessary. You can order the records however you want using DF/SORT or Syncsort. Simply use the path as your SORTIN. If you are using COBOL then a SORT verb can do it too. If you are using PL/I then PLISRTA(), PLISRTB() and PLISRTD() can do it. -- Regards, Dave [RLU #314465] *-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* david.w.n...@googlemail.com (David W Noon) *-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
