 |
» |
|
|
|
Generates the SQL commands necessary to recreate an entire
DBEnvironment. Scope | |
SQLGEN Only SQLGEN Syntax | |
>> [GENERATE]ALL 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 ALL generates a set of commands that can be used to migrate
all the objects of a DBEnvironment.
GENERATE ALL does not generate the CREATE SCHEMA statement.
GENERATE ALL calls all the GENERATE
commands except GENERATE LOAD and GENERATE STATISTICS. All
objects are selected for each GENERATE command.
The commands are called in the following order:
GENERATE DBE
GENERATE DBEFILES
GENERATE SPECAUTH
GENERATE DEFAULTSPACE
GENERATE TEMPSPACES
GENERATE GROUPS
GENERATE PARTITION
GENERATE TABLES
GENERATE SPECAUTH
GENERATE TABAUTH
GENERATE INDEXES
GENERATE VIEWAUTH
GENERATE VIEWS
GENERATE PROCEDURES
GENERATE PROCAUTH
GENERATE RULES
GENERATE MODOPTINFO
GENERATE PROCOPTINFO
GENERATE MODAUTH
GENERATE INSTALLAUTH
This is a description of each command:
- GENERATE DBE
builds the commands necessary to start DBE new for a DBEnvironment.
- GENERATE DBEFILES
builds ALLBASE/SQL commands to recreate one or more of the DBEFileSets and associated DBEFiles of the DBEnvironment.
- GENERATE SPACEAUTH
builds ALLBASE/SQL commands to grant SECTIONSPACE and TABLESPACE authority.
- GENERATE DEFAULTSPACE
builds ALLBASE/SQL commands to set the default SECTIONSPACE and
TABLESPACE to certain DBEFileSet.
- GENERATE TEMPSPACES
builds ALLBASE/SQL commands to recreate one or more of the TEMPSPACEs of the DBEnvironment.
- GENERATE GROUPS
builds SQL commands to recreate all the groups of the DBEnvironment. It generates CREATE GROUP as well as commands to add users/groups to a group.
- GENERATE PARTITION
builds ALLBASE/SQL commands to recreate one or more of the PARTITIONs of the DBEnvironment.
- GENERATE TABLES
builds CREATE TABLE commands to recreate one or more tables of the DBEnvironment. You can also recreate associated indexes and table authorities for specified tables.
- GENERATE SPECAUTH
builds ALLBASE/SQL commands to recreate DBA, CONNECT and RESOURCEauthorities for a DBEnvironment.
- GENERATE TABAUTH
builds ALLBASE/SQL commands to recreate authorities for one or more tables of the DBEnvironment.
- GENERATE INDEXES
builds SQL commands to recreate one or more indexes of the DBEnvironment.
- GENERATE VIEWAUTH
builds ALLBASE/SQL commands to recreate authorities for one or
more views of the DBEnvironment.
- GENERATE VIEWS
builds CREATE VIEW commands to recreate one or more views of the DBEnvironment.
- GENERATE PROCEDURES
builds CREATE PROCEDURE commands to recreate one or more procedures of the DBEnvironment.
- GENERATE PROCAUTH
builds GRANT EXECUTE commands to allow you to recreate authorities for one or more procedures stored in the DBEnvironment.
- GENERATE RULES
builds SQL commands to recreate one or more rules of the DBEnvironment.
- GENERATE MODOPTINFO
builds ALLBASE/SQL commands to generate modified access plans of
sections belonging to certain modules.
- GENERATE PROCOPTINFO
builds ALLBASE/SQL commands to generate modified access plans of
sections belonging to certain procedures.
- GENERATE MODAUTH
builds GRANT RUN commands to allow you to recreate authorities
for one or more modules stored in the DBEnvironment.
- GENERATE INSTALLAUTH
builds GRANT INSTALL commands to recreate all Module Authorities in the DBEnvironment
Example | |
>> gen all
ALLBASE/SQL Command Generator for ALL
Schema File Name or '//' to STOP command >> partschm
Generating command to START DBE PARTSDBE
Generating command to CREATE DBEFILESET ORDERFS
Generating command to CREATE DBEFILESET PURCHFS
. .
. .
Generating command(s) for DBEFILE ORDERDATAF1
Generating command(s) for DBEFILE ORDERINDXF1
. .
. .
Generating CREATE GROUP AJ@SERED.ACCOUNTSPAYABLE
Generating CREATE GROUP AJ@SERED.DBEUSERS
. .
. .
Generating ADD JIM@FRANCIS TO GROUP ACCOUNTSPAYABLE
Generating ADD KAREN@RIZZO TO GROUP ACCOUNTSPAYABLE
. .
. .
Generating CREATE TABLE PURCHDB.INVENTORY
Generating CREATE TABLE PURCHDB.ORDERITEMS
. .
. .
Generating CREATE INDEX on PURCHDB.INVENTORY
Generating CREATE INDEX on PURCHDB.ORDERITEMS
. .
. .
Generating Authority for PURCHDB.INVENTORY
Generating Authority for PURCHDB.ORDERITEMS
. .
. .
Generating Special Authority for AJ@SERED
Generating Special Authority for JOHN@BROCK
. .
. .
>>
|
Schema File Produced | |
START DBE 'PARTSDBE' MULTI NEW
DUAL LOG,
BUFFER = (100, 24),
TRANSACTION = 5,
DBEFILE0 DBEFILE PARTSDBE0
WITH PAGES = 150,
NAME = 'PARTSF0',
LOG DBEFILE DBELOG1 AND DBELOG2
WITH PAGES = 256,
NAME = 'PARTSLG1'
AND 'PARTSLG2';
CREATE DBEFILESET ORDERFS;
CREATE DBEFILESET PURCHFS;
CREATE DBEFILESET RECFS;
CREATE DBEFILESET WAREHFS;
CREATE DBEFILE ORDERDATAF1
WITH PAGES = 50, NAME = 'ORDERDF1',
TYPE = TABLE;
ADD DBEFILE ORDERDATAF1 TO DBEFILESET ORDERFS;
CREATE DBEFILE ORDERINDXF1
WITH PAGES = 50, NAME = 'ORDERXF1',
TYPE = INDEX;
ADD DBEFILE ORDERINDXF1 TO DBEFILESET ORDERFS;
. .
. .
COMMIT WORK;
CREATE GROUP AJ@SERED.ACCOUNTSPAYABLE;
CREATE GROUP AJ@SERED.DBEUSERS;
. .
. .
ADD JIM@FRANCIS TO GROUP ACCOUNTSPAYABLE;
ADD KAREN@RIZZO TO GROUP ACCOUNTSPAYABLE;
. .
. .
COMMIT WORK;
CREATE PUBLIC TABLE PURCHDB.INVENTORY
(PARTNUMBER CHAR( 16) NOT NULL,
BINNUMBER SMALLINT NOT NULL,
QTYONHAND SMALLINT,
LASTCOUNTDATE CHAR( 8),
COUNTCYCLE SMALLINT,
ADJUSTMENTQTY SMALLINT,
REORDERQTY SMALLINT,
REORDERPOINT SMALLINT) IN WAREHFS;
. .
. .
COMMIT WORK;
CREATE UNIQUE INDEX INVPARTNUMINDEX
ON PURCHDB.INVENTORY
(PARTNUMBER);
. .
. .
COMMIT WORK;
GRANT SELECT,
INSERT,
DELETE,
UPDATE
ON PURCHDB.INVENTORY TO DBEUSERS;
GRANT SELECT,
INSERT,
DELETE,
UPDATE
ON PURCHDB.INVENTORY TO PURCHASING;
. .
. .
COMMIT WORK;
GRANT DBA TO AJ@SERED;
GRANT DBA TO JOHN@BROCK;
COMMIT WORK;
|
|
