Placing labels on tables

Use the Label Table (ADB26LT) panel to place a label on a table.

Procedure

  1. 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
  2. Specify option 4, and press Enter.
  3. 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    ===>
  4. 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.
  5. 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.