HP 3000 Manuals

ALLBASE/SQL Database Administration Guide

GENERATE INDEXES 

Generates the SQL commands necessary to recreate indexes for one or more
tables of the DBEnvironment.

Scope 

SQLGEN Only

SQLGEN Syntax 

>> [GEN[ERATE]]INDEX[ES]  Schema File Name or '//' to STOP command >>

SchemaFileName  Owner Name >> OwnerName  Do you wish to specify Table

Names for each Owner (n/y)?  {N[O] } Table Name for Owner OwnerName >>
                             {Y[ES]}

TableName 

Parameters 

SchemaFileName          is the name of the schema file where SQLGEN
                        places the generated commands.

OwnerName               is the name of the Owner for whom you want to
                        GENERATE INDEXES.

NO or YES               respond YES to specify certain tables for the
                        named owner; respond NO to select all table names
                        for the owner.

TableName               is the name of a table for which you wish to
                        GENERATE INDEXES.

Example 

     >> generate indexes 

     ALLBASE/SQL Command Generator for INDEXES

     Schema File Name or '//' to STOP command >> indxpart 

     Please enter Owner Names. Type @ for all, ? for a list of
     Owner Names, or RETURN to quit.

     Owner Name >> @ 
     Do you wish to specify Table Names for each Owner (n/y)? n 

     Generating CREATE INDEX on PURCHDB.INVENTORY
     Generating CREATE INDEX on PURCHDB.ORDERITEMS
            .                  .
     >>

Schema File Produced 

       CREATE UNIQUE INDEX INVPARTNUMINDEX
        ON PURCHDB.INVENTORY
        (PARTNUMBER);

     CREATE CLUSTERING INDEX ORDERITEMINDEX
        ON PURCHDB.ORDERITEMS
        (ORDERNUMBER);

     CREATE CLUSTERING INDEX ORDERNUMINDEX
        ON PURCHDB.ORDERS
        (ORDERNUMBER);
            .               .
            .               .
            .               .

     COMMIT WORK;
[REV BEG]

MPE/iX 5.5 Documentation