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

GENERATE PROCOPTINFO

Technical documentation

» Table of Contents

» Index

Scope

SQLGEN Syntax

Parameters

Example

Schema File Produced