You can invoke a procedure that is stored in a database using the ESQL CALL statement with an EXTERNAL clause.
Stored procedures in SQLServer are not supported as well as overloaded procedures to any database. (An overloaded procedure is one that has the same name as another procedure in the same database schema with a different number of parameters, or parameters with different types.) If the broker detects that a procedure has been overloaded, it raises an exception.
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 indicates that the schema name is dynamic and is resolved on the CALL statement (see below).
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_ |