HP 3000 Manuals

ALLBASE/SQL Database Administration Guide

GENERATE PROCOPTINFO 

Generates SQL commands necessary to recreate modified access plans for
procedure sections.

Scope 

SQLGEN Only

SQLGEN Syntax 

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

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

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

>> ProcedureName 

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 wish to
                        generate modified access plans.

NO or YES               respond NO to specify all procedure names for the
                        owner; respond YES to specify certain procedure
                        names for the owner.

ProcedureName           is the name of a procedure for which you wish to
                        generate modified access plans.

Example 

     >> PROCOPTINFO 

     ALLBASE/SQL Command Generator for Procedure Setoptinfo

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

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

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

     Generating command to SETOPT for Procedure PURCHDB.PROC1

     Generating command to SETOPT for Procedure PURCHDB.PROC2

     Owner Name >> Return 

Schema File Produced 

     SETOPT GENERAL SERIALSCAN;
     VALIDATE PROCEDURE SECTION
       PURCHDB.PROC1(1);

     SETOPT GENERAL SERIALSCAN;
     VALIDATE PROCEDURE SECTION
       PURCHDB.PROC2(1);

     SETOPT CLEAR;

     COMMIT WORK;

MPE/iX 5.5 Documentation