With the execute, open, or get statements, you may call a SQL stored procedure; in each instance, the #sql directive is used. A stored procedure, like an EGL function, is a collection of instructions for a database.

You can call an SQL stored procedure with the execute, open, or get statement; in each case, you use the #sql directive. A stored procedure is a set of instructions for a database, like a function in EGL.

You can call an SQL stored procedure with the execute, open, or get statement; in each case, you use the #sql directive. A stored procedure is a set of instructions for a database, like a function in EGL.

The SQL CALL statement can be used to invoke a stored procedure. A user’s role must have the USAGE privilege for the stored procedure in order for the user to call it. Once you have the privileges to call the stored procedure, you can do so with a CALL statement.