Create Table: Table Referential Constraint panel

Panel and field definitions

  Process   Options   Utilities   Help
 ──────────────────────────────────────────────────────────────────────────────
 FM/Db2 (DFG2)     Create Table: Table Referential Constraint   Row 1 to 1 of 1

 Constraint:
    Name  . . . . . . . . . CON1
    Parent Table Owner  . .
    Parent Table Name . . . EMP

 Order Column Name        Data Type(Length) Parent Key Column
       COL1               CHAR(3)                             
 ******************************* Bottom of data ********************************









 Command ===>                                                       Scroll PAGE
  F1=Help      F2=Split     F3=Exit      F7=Backward  F8=Forward   F9=Swap
 F12=Cancel

Name

The name of the constraint.

Parent Table Owner

The name of the parent table owner.

Parent Table Name

The name of the parent table.

Order

Enter S or a number to add a column to the foreign key. When you enter S, FM/Db2 generates the next highest number for the key. To deselect a column that is already selected, clear the displayed number by overtyping it with spaces.

Note: The actual numbers are not important; FM/Db2 uses their relative order to define the column order for the key.

Column Name

The name of the column in the table you are creating.

Data Type(Length)

The data type of the column in the table you are creating.

Parent Key Column

Specify the name of the column in the parent table that you want to relate to the foreign key column (Column Name) you have ordered. If you leave this field blank, FM/Db2 relates the foreign key to the primary key of the parent table.

Note: If you have selected more than one column for the foreign key (by entering S or a number in the Order field), the corresponding Parent Key Columns must all be blank or all be filled.