IBM Support

Can Primary key of the tables be used for sorting based on creation time in Sterling Order Management?

Question & Answer


Question

Can Primary key of the tables be used for sorting based on creation time in IBM Sterling Order Management?

Answer

Primary key is a combination of timestamp and sequence number. When the number of records increase in the table then sequence number also increases. This translates to a change in key length from 21 to 22, so on and so forth.
In most cases the primary keys and the createts are ordered the same way. However you also have the option to randomize any table by adding KeyType="Random" in the entity xml. This could clash with the order of the time stamp

Starting from version 9.2, the application allows some tables to be randomized by default. In addition to this there is an option of generating custom primary keys as well.

If you are certain that the Primary key generation for table YFS_CHARGE_TRANSACTION is not randomized or custom generated and if you do not have any plans in the future to make any change to this, you can sort by Primary Key.

The application already provides the createts  field which will help to sort with creation time, it is recommended that you use the same column instead of the primary key column.

[{"Product":{"code":"SS6PEW","label":"Sterling Order Management"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Documentation","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.1;9.2;9.2.1;9.3","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Document Information

Modified date:
16 June 2018

UID

swg21684075