Create Table: Generate Values panel

Panel and field definitions

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

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

                                          Gen   As                Caching
                                          (A/D) Idty  Start Incr  Option
 Column Name      + Data Type (Length)  + (Y/N) (Y/N) value value (0=NO CACHE)

 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

Column Name

The name of the column in the table you are creating for which you want Db2® to create values.

Gen (A/D)

Determines when Db2® generates values for the column. Valid values are:

(blank)

Values not generated for this column.

A

Values always generated for this column when a new row is inserted into the table.

D

Values generated for this column when a new row is inserted unless a value is specified.

As Idty (Y/N)

Identifies whether the column is the identity column for the table (there can be only one).

N (or blank)

Column is not an identity column.

Y

Column is the identity column for the table.

Start value

Starting value for generating identity column values (integer).

Incr value

Interval between consecutive generated identity column values (non-zero integer).

Caching Option

An integer specifying how many preallocated values of the identity column are kept in memory to improve performance. Valid values:

0

Generates a NO CACHE clause.

n

Generates a NO CACHE nclause. n must be 2 or more.