IBM Support

Creating a custom sequence for a database table in Sterling Order Management System.

Question & Answer


Question

How do you create a custom sequence for a database table in IBM Sterling Order Management System ?

Cause

You want to have custom sales order and purchase order number sequence.

Answer

You can create a custom sequences through entity extension xmls much like adding a new column to tables.

Below is the example of entity extension xml :
================
<DBSchema>
   <Entities>
         .......
         .......
          <Sequence Name="SEQ_CUSTOM" Increment="1" Startwith="1" Maxvalue="9999999999" Minvalue="1" Cachesize="100" Order="false" TableType="TRANSACTION">Sequence>
    </Entities>
</DBSchema>
================

NOTE: The sequence once created through entity framework cannot be modified or deleted using entity extensions.

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS6PEW","label":"Sterling Order Management"},"Component":"","Platform":[{"code":"PF016","label":"Linux"}],"Version":"All versions","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Document Information

Modified date:
30 July 2018

UID

ibm10719239

Page Feedback