HP 3000 Manuals

ALLBASE/SQL Database Administration Guide

GENERATE GROUPS 

Generates SQL commands necessary to recreate the groups of a
DBEnvironment.

Scope 

SQLGEN Only

SQLGEN Syntax 

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

SchemaFileName 

Parameters 

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

Description 

   *   GENERATE GROUPS builds the commands necessary to recreate all the
       groups of a DBEnvironment.  It generates CREATE GROUP as well as
       commands to add users/groups to a group.

Example 

     >> generate group 

     ALLBASE/SQL Command Generator for Groups

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

     Generating CREATE GROUP AJ@SERED.ACCOUNTSPAYABLE
                          .             .
                          .             .
     Generating ADD JIM@FRANCIS TO GROUP ACCOUNTSPAYABLE
     Generating ADD KAREN@RIZZO TO GROUP ACCOUNTSPAYABLE
            .             .
            .             .

     >>

Schema File Produced 

     CREATE GROUP AJ@SERED.ACCOUNTSPAYABLE;

     CREATE GROUP AJ@SERED.DBEUSERS;

     CREATE GROUP AJ@SERED.PURCH;
             .               .
             .               .
             .               .

     ADD JIM@FRANCIS TO GROUP ACCOUNTSPAYABLE;

     ADD KAREN@RIZZO TO GROUP ACCOUNTSPAYABLE;

     ADD STACEY@WOLF TO GROUP ACCOUNTSPAYABLE;
             .               .
             .               .
             .               .

     COMMIT WORK;

MPE/iX 5.5 Documentation