Creating SQL Objects › Creating a Schema › Example Output Member

Example Output Member

The following example is the Output Panel received after executing the previous CREATE SCHEMA statement.

 =>
 =>
 =>
 
 --------------------------------------------------------------------------- >>>
 Interactive SQL Service Facility                                       SQLMAINT
 
                                 Output Panel                               S01O
              EDIT     Member= $DDSQL
                  Description: CREATE A SCHEMA
 -------------------------------------------------------------------------------
 ====== ========================== T O P =======================================
 000001 (OUTPUT CREATED FROM SOURCE MEMBER $DDSQL  )
 000002 create schema authorization jones;
 000003 ---------+---------+---------+---------+---------+---------+---------+--
 000004 STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 0
 000005 ---------+---------+---------+---------+---------+---------+---------+--
 000006 SQL STATEMENTS ASSUMED TO BE BETWEEN COLUMNS 1 AND 72
 000007 NUMBER OF INPUT RECORDS READ IS 0001
 000008 NUMBER OF SQL STATEMENTS PROCESSED IS 0001
 ====== ======================= 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

To exit from the Output Panel, you can perform one of the following.

• Press PF2 (END) to obtain an SQLMAINT Panel where you can select another option.
• Press PF12 (ALTERNATE) to display the Source Panel.
• Press the CLEAR key to return to the Interactive SQL Service Facility Panel.