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] Y[ES] } Module Name for Owner OwnerName >> 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;

GENERATE MODOPTINFO

Technical documentation

» Table of Contents

» Index

Scope

SQLGEN Syntax

Parameters

Example

Schema File Produced