Create Table: Column Check Constraints panel

You use the Create Table: Column Check Constraints panel to specify information to define column check constraints for the table.

Panel and field definitions

  Process   Options   Utilities   Help
 ──────────────────────────────────────────────────────────────────────────────
 FM/Db2 (DFG2)       Create Table: Column Check Constraints     Row 1 to 1 of 1

    Owner . . . . . . .                                                        +
    Name  . . . . . . . TAB1                                                   +
    Database  . . . . .
    Table Space . . . .
                                                                Check
 Sel Column Name      + Data Type(Length)  + Constraint Name  + Condition      +
     COL1               CHAR(3)                                                 
 ******************************* Bottom of data ********************************









 Command ===>                                                       Scroll PAGE
  F1=Help      F2=Split     F3=Exit      F4=Expand    F5=Tabcons   F7=Backward
  F8=Forward   F9=Swap     F10=Left     F11=Right    F12=Cancel
Sel
Type S in this field to display a scrollable panel that use to specify a check condition up to the maximum length permitted by Db2®. See the description for the Check Condition entry field.
Column Name
The name of the column in the table you are creating.
Data Type(Length)
The data type and length of the column in the table you are creating.
Constraint Name
The name of the constraint. This is an optional field.
Check Condition
SQL expression defining the column check constraint.

If you need to specify a check condition that is too long to fit in the entry field on the panel, enter S in the Sel field to display a panel. If a long check condition already exists and you alter the part of the check condition displayed on the Column Check Constraints panel, FM/Db2 displays the same panel that you can use to confirm the changes you have made.

Note: FM/Db2 does not validate the check condition you specify.

Parent panels

Child panels

None.

Related tasks