You can invoke a procedure that is stored in a database using the ESQL CALL statement with an EXTERNAL clause.
When you invoke a stored procedure with the CALL statement, the broker ensures that the ESQL definition and the database definition match:
If you specified a single percent character for the schema name when you created the procedure, this character indicates that the schema name is dynamic and is resolved on the CALL statement (see below).
The following restrictions apply to the use of stored procedures:
When you define an ESQL procedure that corresponds to a database stored procedure, you can specify either a qualified name (where the qualifier is a database schema) or an unqualified name.
To create a stored procedure:
Notices |
Trademarks |
Downloads |
Library |
Support |
Feedback
![]() ![]() |
ac17040_ |