Create Table: Model Load panel

You use the Create Table: Model Load panel to control what information about a model table is loaded into the ISPF variables and tables used to generate the CREATE TABLE statement. The panel also allows you to specify whether the load is a refresh of the current information, or adds to it.

Panel and field definitions

  Process   Options   Utilities   Help
 ──────────────────────────────────────────────────────────────────────────────
 FM/Db2 (DFG2)              Create Table: Model Load

 Press enter to load the selected information for the model table/view, or
 press PF3 (End) or PF12 (Cancel) to cancel the load.

 Model Table/View:
    Owner . . . .  FMNUSER           +
    Name  . . . .  MODEL2                                              +

 Model Load Options:
    Enter '/' to load                                         Refresh/Add
    /  Basic table information   /  Unique key information    1 1. Refresh
    /  Column information        /  Referential constraints     2. Add
    /  Primary key information   /  Check constraints

    Load single-column referential constraints as
    1 1. Column referential constraints
      2. Table referential constraints


 Command ===>                                                                  
  F1=Help      F2=Split     F3=Exit      F4=Expand    F7=Backward  F8=Forward
  F9=Swap     F10=Left     F11=Right    F12=Cancel
Owner
The name of the owner of the model table.
Name
The name of the model table.
Basic table information
Database name, table space name if explicitly defined for the model table, and all the table options values for the model table or view. (See following Note.)
Column information
Column names and data types, and nulls and default values specifications for the model table or view. (See following Note.)
Primary key information
Column order in the primary key of the model table.
Unique key information
Column order for the first three unique keys in the model table.
Referential constraints
Referential constraints for the model table.
Check constraints
Check constraints for the model table.
1. (Refresh)
Discard all current CREATE TABLE information, whether manually entered or from a previous load, and load the new selected information for the model table or view.
2. (Add)
Add the selected type of information for the model table or view to the current information for the new table.
Note: If you select the Add option, you can only select Basic table information and Column information. FM/Db2 only loads basic table information if the target field is blank.
Load single-column referential constraints as
If the model table has referential constraints, whether you want single-column referential constraints loaded as column referential constraints or table referential constraints.
1. Column referential constraints
Single-column referential constraints associated with the foreign key column.
2. Table referential constraints
Single-column referential constraints not associated with the foreign key column. (The associated constraint names are kept regardless of the level of the currently connected Db2® system.)

Parent panels

Child panels

None.

Related tasks