Create Index: Column Selection panel

You use the Create Index: Column Selection panel to select the columns that comprise the index.

Panel and field definitions

  Process   Options   Utilities   Help
                                                                                
 FM/Db2 (DFG2)           Create Index: Column Selection         Row 1 to 1 of 1

 New Index:
    Owner . . . . . . .                                                     +
    Name  . . . . . . . IND1                                                +
    Table owner . . . .                                                     +
    Table name  . . . . TABLE1                                              +

 Sel Ord (A/D) Column Name                    Datatype(length)   + Null Attr.
               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
Owner
The name of the owner of the new index.
Name
The name of the new index.
Table owner
The SQLID used to create the table on which the index is being defined.
Table name
The table on which the index is created.
The bottom half of the panel shows a table that can be scrolled in the usual ISPF manner.
Sel
An input selection field. This is where you identify the columns that make up the index. You can enter S to select or deselect any column. You can also type a number against a column, to indicate the ordering of the columns in the index.
Order
A display-only field. Possible values are spaces, indicating this column is not part of the index; or a number, indicating that this column has been selected as part of the index, and its order among the selected columns.
(A/D)
Indicates how the values in the column are to be indexed. If Sel is blank, but A/D is not blank, it is as if Sel contains S. The available options are:
A
Ascending. This is the default. If you do not specify a value, this field is filled with an A when the panel is redisplayed.
D
Descending
Column Name
The name of the column.
Data Type(length)
The Db2® data type of the column.
Null Attribute
Shows whether column allows null values.

Parent panels

Child panels

None.

Related tasks