Assign a Data Type to a Sequence

Using the Type command, you can select and assign a data type for a sequence. You can choose a built-in type or user-defined distinct type (UDT).
carcudb2
Using the Type command, you can select and assign a data type for a sequence. You can choose a built-in type or user-defined distinct type (UDT).
The initial list that is presented is built using the current Type Schema that is specified for the sequence, with all remaining selection criteria (Item Name, Source Schema, and Source Type) set to asterisk (*).
Follow these steps:
  1. Enter
    TYPE
    in the command line of a sequence create, alter, or template panel.
    The Sequence Data Type Selection panel appears.
  2. (Optional) Enter additional selection criteria for any of the following fields to customize the listed information:
    • Item Name
    • Schema
    • Src Schema
    • Src Type
    The listed information changes according to your specifications.
  3. Enter
    S
    next to the name of the data type that you want to assign.
    The sequence create, alter, or template panel appears, with your new data type assigned to the sequence.