Tables

The Tables option screen (see the following figure) displays when you select option 1 from the Object Selection menu. It lets you specify whether you want to create, alter, drop, rename, or model a table.

Tables Options Screen

Menu Utilities Help
-----------------------------------------------------------------------------------
File-AID for DB2                                Tables                SSID ===> DSN
OPTION ===>

   C - Create TABLE
   A - Alter TABLE
   D - Drop   TABLE
   R - Rename TABLE
   M - Model TABLE

Specify Table Information:      (* or pattern for List)
Creator       ===>
Table Name    ===>

OPTION

Specify the letter that represents the activity you want to perform.

C	Create a table.
A	Alter a table.
D	Drop a table.
R	Rename a table.
M	Model a table and create a new table.

Specify Table Information: (* or pattern for List) Area

Creator

Specify your creator ID. This field is required. You can also specify a generic name with * (asterisk) or a pattern. This displays a selection window (see the following figure), from which you can select a specific object.

Tables Selection (Creator)

Table Name

Specify the name of the table you want to create, alter, drop, or model. This field is required. You can also specify a generic name with * (asterisk), or a pattern. This displays a selection window (see the following figure), from which you can select a specific object.

Table Selection (Table Name)

Important

When you press Enter from the Tables screen, or from the Table Selection window, File-AID for Db2 Object Administration displays. Refer to the File-AID for Db2 Object Administration User Reference manual for information.