 |
» |
|
|
|
Generates SQL commands to recreate one or more rules in
a DBEnvironment.
Scope | |
SQLGEN only SQLGEN Syntax | |
>> [GENERATE] RULE[S] Schema File Name or '//' to STOP command >> SchemaFileName
Owner Name >> OwnerName
Do you wish to specify Rule Names for each Owner (n/y)? { N [O] Y [ES]} Rule Name for Owner OwnerName >> RuleName
Parameters | |
- SchemaFileName
is the name of the schema file where SQLGEN places generated commands.
- OwnerName
is the name of the owner whose rules you wish to generate.
- NO or YES
respond NO to select all rules for the owner; respond
YES to select certain rules for the owner.
- RuleName
is the name of a rule you wish to generate.
Description | |
GENERATE RULES builds CREATE RULE commands to recreate one or more
rules in
the DBEnvironment.
Example | |
>> generate rules
ALLBASE/SQL Command Generator for Rules
Schema File Name or '//' to STOP command >> partrschema
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 Rule Names for each Owner (n/y)? n
Generating command to CREATE RULE PURCHDB.INSERTREPORT
Generating command to CREATE RULE PURCHDB.UPDATEREPORT
Generating command to CREATE RULE PURCHDB.DELETEREPORT
Owner Name >> Return
>>
|
Schema File Produced | |
/* This file was created with a user language environment of */
/* NATIVE-3000 */
CREATE RULE PURCHDB.INSERTREPORT
AFTER INSERT
ON PURCHDB.REPORTS
execute procedure PurchDB.ReportMonitor (NEW.ReportName,
NEW.ReportOwner, 'INSERT');
CREATE RULE PURCHDB.UPDATEREPORT
AFTER UPDATE(REPORTOWNER,REPORTNAME)
ON PURCHDB.REPORTS
execute procedure PurchDB.ReportMonitor (NEW.ReportName,
NEW.ReportOwner, 'UPDATE');
CREATE RULE PURCHDB.DELETEREPORT
AFTER UPDATE
ON PURCHDB.REPORTS
execute procedure PurchDB.ReportMonitor (OLD.ReportName,
OLD.ReportOwner, 'DELETE');
COMMIT WORK;
|
|
