Previous Topic: Statement Execution ResultsNext Topic: Example Output Member

Creating SQL Objects › Altering a Table › Example Source Member

Example Source Member

The following example shows an ALTER TABLE statement. See How to Submit SQL Statements for the steps to obtain the Source Panel and an explanation of the fields.

 =>
 =>
 =>
 
 -------------------------------------------------------------------------------
 Interactive SQL Service Facility                                       SQLMAINT
 
                                 Source Panel                               S01S
            EDIT     Member: DEPTTBL2  Output Line Limit: 01000
                     Person: JONES
             Current Authid: JONES
                Description: ADD ADMDEPT TO DEPTTBL
 -------------------------------------------------------------------------------
 ====== ========================== T O P =======================================
 000001 alter table depttbl
 ......   add admdept char(2);
 ====== ======================= B O T T O M ====================================
 
 
 
 
 PF1=HELP         PF2=END         PF3=SPLIT         PF4=PROCESS
 PF5=TOP          PF6=BOTTOM      PF7=BACKWARD      PF8=FORWARD
 PF9=EXECUTE      PF10=LEFT       PF11=RIGHT        PF12=ALTERNATE

Before entering the statement, we inserted an additional line on the panel by typing i1 in the line number and pressing Enter.

The statement ALTER TABLE is required and must be followed by the name of the table, which is DEPTTBL in this example.

The column definition is listed on a separate line. Since only one column is added, the parentheses are not required.

For information on the ALTER TABLE statement, see ALTER TABLE.

After placing your SQL statement in the numbered line area on the Source Panel, you can perform the following: