The following example is the Output Panel received when executing the previous statement.
=> => => --------------------------------------------------------------------------- >>> Interactive SQL Service Facility SQLMAINT Output Panel S01O EDIT Member= DEPTTBL2 Description: ADD ADMDEPT TO DEPTTBL ------------------------------------------------------------------------------- ====== ========================== T O P ======================================= 000001 (OUTPUT CREATED FROM SOURCE MEMBER DEPTTBL2) 000002 alter table depttbl 000003 add admdept char(2); 000004 ---------+---------+---------+---------+---------+---------+---------+-- 000005 STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 0 000006 ---------+---------+---------+---------+---------+---------+---------+-- 000007 SQL STATEMENTS ASSUMED TO BE BETWEEN COLUMNS 1 AND 72 000008 NUMBER OF INPUT RECORDS READ IS 0002 000009 NUMBER OF SQL STATEMENTS PROCESSED IS 0001 PF1=HELP PF2=END PF3=SPLIT PF4=PROCESS MORE... PF5=TOP PF6=BOTTOM PF7=BACKWARD PF8=FORWARD PF9=EXECUTE PF10=LEFT PF11=RIGHT PF12=ALTERNATE
The column ADMDEPT is added after the existing columns in the table. If the table has existing rows, the rows receive NULL values in the added column unless NOT NULL WITH DEFAULT is specified with a column constraint definition. The length of the column is added to the table's element SQLEL.
To exit from the Output Panel, you can perform one of the following.
|
Copyright © 2014 CA.
All rights reserved.
|
|