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.
Was this topic helpful?
Document Information
Modified date:
30 July 2018
UID
ibm10719239