Generates SQL commands necessary to recreate the groups of a
DBEnvironment.
Scope
SQLGEN Only
SQLGEN Syntax
>> [GENERATE]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;
