Creating SQL Objects › Creating an Index › Example Source Member

Example Source Member

The following example shows a CREATE INDEX 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: $DDSQL    Output Line Limit:  01000
                     Person: JONES
             Current Authid: JONES
                Description: CREATE INDEX EMPLOYEE_INDEX
 -------------------------------------------------------------------------------
 ====== ========================== T O P =======================================
 000001 create index employee_index on employees (empno);
 ====== ======================= 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

The statement CREATE INDEX is required and must be followed by the name of the index (employee_index in this example) the word "on", the table name (employees), and the column-list (empno). For information on the syntax of the CREATE INDEX statement, see CREATE INDEX.

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

• Enter additional SQL statements. Place a semicolon (;) after each complete statement.
• Press PF9 (EXECUTE) to execute the source member. CA Datacom Datadictionary responds with the Output Panel which shows the results of the SQL processing.
• Press PF2 (END) to obtain an SQLMAINT Panel where you can select another option.
• Press the CLEAR key to return to the Interactive SQL Service Facility Panel where you can choose another option.