Adding Constraint to generate Customer ID

Procedure

  1. In the Palette, click the Constraint icon in the Declare Constraint section and then click the Declare Constraints compartment to add the constraint.
  2. Provide the following details for the constraint in the Properties window:
    • Name as GenerateCustomerID
    • Description as Auto generate ID for Customer.
  3. Double click the GenerateCustomerID constraint to open up the Expression Editor.
  4. From the Actions Palette, click the Assign Action icon and then click in the Actions compartment to insert it. Provide the following properties:
    • Name as ActionName
    • Select PRODUCTID from the Assign drop-down.
    • In the Expression Editor, enter the following:
sequence('MQ_SEQUENCE_1')