Create Table: Table Check Constraints panel

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

Cmd

Line command area. Use the following line commands to manipulate the panel rows containing table check constraint information:

In

Insert n new rows.

Rn

Repeat the current row n times.

Dn

Delete n rows.

S

Select a row. FM/Db2 displays a scrollable panel that you use to specify a check condition up to the maximum length allowed by Db2®. See the description for the Check Condition field.

Constraint Name

The name of the constraint. This is an optional field.

Check Condition

SQL expression defining the table check constraint.

If you need to specify a check condition that is too long to fit in the field on the panel, enter S in the Cmd field to display a panel. If a long check condition already exists and you alter the part of the check condition displayed on the Table 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.