HP 3000 Manuals

ALLBASE/SQL Database Administration Guide

GENERATE MODOPTINFO 

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

Scope 

SQLGEN Only

SQLGEN Syntax 

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

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

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

ModuleName 

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 module names for the
                        owner; respond YES to specify certain module
                        names for the owner.

ModuleName              is the name of a module for which you wish to
                        generate modified access plans.

Example 

     >> MODOPTINFO 

     ALLBASE/SQL Command Generator for Module Setoptinfo

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

     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 Module Names for each Owner  (n/y)? n 

     Generating command to SETOPT for Module PURCHDB.MOD1

     Generating command to SETOPT for Module PURCHDB.MOD2

     Owner Name >> Return 

Schema File Produced 

     SETOPT GENERAL INDEXSCAN;
     VALIDATE MODULE SECTION
       PURCHDB.MOD1(1);

     SETOPT GENERAL INDEXSCAN;
     VALIDATE MODULE SECTION
       PURCHDB.MOD1(2);

     SETOPT GENERAL INDEXSCAN;
     VALIDATE MODULE SECTION
       PURCHDB.MOD2(1);

     SETOPT CLEAR;

     COMMIT WORK;

MPE/iX 5.5 Documentation