How Database Procedures Are Created
Database procedures can be created using the following methods:
• Ingres Database Procedures - The Ingres DBMS (and some Enterprise Access and EDBC products) allows you to create database procedures using the CREATE PROCEDURE statement.
• Host DBMS Procedures - Enterprise Access and EDBC provide access to procedures located in the host DBMS. (These procedures are created and maintained in the host DBMS.) The procedure must be declared to Enterprise Access or EDBC by issuing the REGISTER PROCEDURE statement. For details regarding support of host DBMS procedures, see your Enterprise Access or EDBC product guide. For details about creating and managing the host DBMS procedures, see your host DBMS documentation.
• Enterprise Access and EDBC Procedures - Enterprise Access and EDBC to host DBMSs that do not support database procedures provide an alternate mechanism for database procedures: object code modules for the routine are linked into the Enterprise Access or EDBC executable program. These routines must be declared to Enterprise Access or EDBC by issuing the REGISTER PROCEDURE statement. For details on the creating and registering this kind of procedure, see your Enterprise Access or EDBC product guide.
• Ingres Star - Using Ingres Star, you can execute database procedures that are located in a remote database, Enterprise Access, or EDBC.
Note: OpenSQL does not control the transaction behavior that occurs when executing a database procedure. Transaction behavior is determined by the host DBMS.