Whilst creating stored procedures SPGen allows users to specify the following
options:
-
Procedure Prefix.
-
Variable Prefix.
-
In Paramater Prefix.
-
Out Paramater Prefix.
-
Retrieve Primary Key values for Insert procedures
-
Event notification for Inserts, Updates and Deletes.
-
Verify record Exists prior to Update and Delete.
-
Use ALTER OR CREATE syntax.
-
Raise exceptions for null fields.
-
Use Default column values for null fields.
-
Optionally create EXCEPTION objects.
-
Re-Generate SQL script.
-
Modify SQL script.
-
Specify Sort Order for SELECT procedures
-
Optionally specify Generator for Return Param (INSERT)
-
Generate procedures for VIEWS.
-
Specify multiple tables or views.
-
Optionally ommit creation of Exceptions that already exist.
-
Optionally call EVENT's for INSERT, DELETE and UPDATE procedures.
All these options are designed to give usersof SPGen fine grained control on
the Stored Procedures which are generate.
|