Placing labels on tables
Use the Label Table (ADB26LT) panel to place a label on a table.
Procedure
-
On the DB2 Administration Menu
(ADB2) panel, specify option
2, and press Enter.
The Execute SQL Statements (ADB22) panel is displayed, as shown in the following figure:
Figure 1. Execute SQL Statements (ADB22) panel DB2 Admin -------------------- Execute SQL Statements ------------------- 01:36 Option ===> 1 - Edit/run SQL statements DB2 System: DD1A 2 - Run or Explain SQL statements DB2 SQL ID: ADM001 3 - Build SQL SELECT, INSERT, UPDATE or DELETE prototype 4 - Create/drop/label/comment on objects 5 - Grant/revoke privileges on objects
- Specify option 4, and press Enter.
-
Specify option LT, and press Enter.
The Label Table (ADB26LT) panel is displayed, as shown in the following figure.
Figure 2. Label Table (ADB26LT) panel DB2 Admin --------------------- DD1A Label Table ------------------------ 15:34 Command ===> Owner ===> OWNER1 > Name ===> TABLE10 > (? to look up) IS Label ===>
-
Specify the following values, and press Enter.
- Owner
- An owner name for the table on which you want to place a label.
- Name
- A table name on which you want to place a label, or enter a question mark (?) to look up existing table names using the Tables, Views, and Aliases (ADB21T) panel.
- Label
- A label for the table.
- Follow the instructions on the Statement Execution Prompt (ADB2PSTM) panel (if enabled) to complete and run the SQL statement for placing the label on the table.