Create Table: Columns panel

You use the Create Table: Columns panel to specify information to define the columns for a table to be created.

Panel and field definitions

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

    Owner . . . . . . .                                                        +
    Name  . . . . . . . TAB1                                                   +
    Database  . . . . .
    Table Space . . . .

                        <---(For Built in Data Types)----->
                                                <DEC>
                                               <FL>   For   User-defined
 Cmd Column Name      + Data Type         Len   Pr Sc Data  Data Type          +
     COL1               CHAR              3                                     
 

******************************* Bottom of data ********************************



 Command ===>                                                       Scroll PAGE
  F1=Help      F2=Split     F3=Exit      F4=Expand    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 column information:
In
Insert n new rows.
Rn
Repeat the current row n times. (See following note.)
Dn
Delete n rows.
Note: When you repeat a row, FM/Db2 repeats only the column information shown on this panel and the Nulls and Default Values panel. All other information is cleared.
Column Name
The name of the column.
Data Type
The data type of the column.
Len
The length of the column being defined. Only use this field for columns with a string data type.
Pr, Sc
The precision and scale for numeric data types.
For a decimal number:
  • Specify the precision (1–31) in the Pr field and the scale (0 to the precision of the number) in the Sc field.
For a single-precision floating point number:
  • If you have specified a data type of FLOAT, specify the precision (1–21) in the Pr field and leave the Sc field blank.
  • If you have specified a data type of REAL, leave the Pr and Sc fields blank.
For a double-precision floating point number:
  • If you have specified a data type of FLOAT, specify the precision (22–53) in the Pr field or leave the Pr field blank, and leave the Sc field blank.
  • If you have specified a data type of DOUBLE, leave the Pr and Sc fields blank.

For a binary integer, leave the Pr and Sc fields blank.

For Data
The subtype to be used in the FOR subtype DATA clause. Only specify a non-blank value for character string columns with a data type of CHAR, VARCHAR, LONG VARCHAR, or CLOB. Valid values are:
(Blank)
FOR DATA clause not generated.
SBCS (or S)
FOR SBCS DATA clause generated.
MIXED (or M)
FOR MIXED DATA clause generated.
BIT (or B)
FOR BIT DATA clause generated. Do not specify BIT for a CLOB column.
User-defined Data Type
Specifies the data type of the column is a distinct type (a user defined-data type). The length, precision and scale of the column (if applicable) are respectively the length, precision and scale of the source type of the distinct type.

Parent panels

Child panels

None.

Related tasks

Related references