To use a host variable name for the stored procedure with an SQLDA, code a statement like this:
EXEC SQL CALL :PROCNAME USING DESCRIPTOR :ADDVALS END-EXEC
This form gives you extra flexibility because you can use the same CALL statement to invoke different stored procedures with different parameter lists.
Your client program must assign a stored procedure name to the host variable PROCNAME and load the SQLDA ADDVALS with the parameter information before making the SQL CALL statement.
Each of the above CALL statement examples uses an SQLDA. If you do not explicitly provide an SQLDA, the precompiler generates the SQLDA based on the variables in the parameter list.
You can execute the CALL statement only from an application program. You cannot use the CALL statement dynamically.