Is it possible to create a secondary index in IMS DB that will arrange the records in the database in descending order of a key field?
Suppose there is an employee number field in the IMS DB which currently is not sorted in any order in the IMS DB. Is it possible to create a secondary index on this field, so that the records will be shown in descending order of the employee number? Or is there any other way to achieve this in IMS DB?
Joined: 02 Mar 2012 Posts: 3 Location: United States
I think what you're looking for is a "tens complement" field. You'd have to determine the "tens complement" of the employee number, then use that as a key field for the secondary index.
I am, I admit, puzzled as to why you would want to do this. If you're looking for a way to assign the next employee number in sequence after the current highest number, many ways exist to accomplish this, and most of them take a smaller amount of work and space. Example: a one-record IMS database (assuming that you are limited to IMS) which is updated when a new employee is hired.