Previous Topic: Example Source MemberNext Topic: Creating a View


Example Output Member

The following example is the Output Panel received when executing the previous CREATE INDEX statement.

=> => => --------------------------------------------------------------------------- >>> Interactive SQL Service Facility SQLMAINT Output Panel S01O EDIT Member= EMPLOYEE Description: CREATE INDEX EMPLOYEE_INDEX ------------------------------------------------------------------------------- ====== ========================== T O P ======================================= 000001 (OUTPUT CREATED FROM SOURCE MEMBER EMPLOYEE) 000002 create index employee_index on employee (empno); 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 MORE... PF5=TOP PF6=BOTTOM PF7=BACKWARD PF8=FORWARD PF9=EXECUTE PF10=LEFT PF11=RIGHT PF12=ALTERNATE

If the display is larger than your screen allows, use the PF keys to scroll to other portions of the display.

In this example, an index is created with the full SQL name of JONES.EMPLOYEE_INDEX and a KEY entity-occurrence is generated by CA Datacom Datadictionary during execution of the CREATE INDEX statement.

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