Create Auxiliary Table panel

You use the Create Auxiliary Table panel to create a new auxiliary table.

Panel and field definitions

  Process   Options   Utilities   Help
                                                                                
 FM/Db2 (DFG2)               Create Auxiliary Table

 Auxiliary table:
    Owner . . . . . . .                   + (optional)
    Name  . . . . . . .                                                     +
 Table Space:
    Name  . . . . . . .         
    Database  . . . . .                     (optional)
 Base Table:
    Owner . . . . . . .                   + (optional)
    Name  . . . . . . .                                                     +
 Base Table Column:
    Name  . . . . . . .                               
    Partition . . . . .                    (optional)




 Command ===>                                                                  
  F1=Help      F2=Split     F3=Exit      F4=Expand    F7=Backward  F8=Forward
  F9=Swap     F10=Left     F11=Right    F12=Cancel
Owner (Auxiliary Table)
Specifies the owner of the auxiliary table.
Name (Auxiliary Table)
Specifies the name of the auxiliary table.
Name (Table Space)
Specifies the LOB table space in which the auxiliary table is created.
Database (Table Space)
Specifies the database to which the specified table space belongs.
Owner (Base Table)
Specifies the owner of the base table containing the LOB column that is stored in the auxiliary table.
Name (Base Table)
Specifies the name of the base table containing the LOB column that is stored in the auxiliary table.
Name (Base Table Column)
Specifies the name of the LOB column in the base table that is stored in the auxiliary table.
Partition (Base Table Column)
For base tables defined in partitioned table spaces, specifies the partition of the base table for which this auxiliary table stores data.

Parent panels

Child panels

None.

Related tasks