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.ACCOUNTSPAYABLE
. .
. .
Generating ADD JIM TO GROUP ACCOUNTSPAYABLE
Generating ADD KAREN TO GROUP ACCOUNTSPAYABLE
. .
. .
>>
Schema File Produced
CREATE GROUP AJ.ACCOUNTSPAYABLE;
CREATE GROUP AJ.DBEUSERS;
CREATE GROUP AJ.PURCH;
. .
. .
. .
ADD JIM TO GROUP ACCOUNTSPAYABLE;
ADD KAREN TO GROUP ACCOUNTSPAYABLE;
ADD STACEY TO GROUP ACCOUNTSPAYABLE;
. .
. .
. .
COMMIT WORK;
