ALLBASE/SQL Reference Manual (36216-90216)

Chapter 11 419
SQL Statements E - R
EXECUTE
If the prepared statement could be an EXECUTE PROCEDURE statement (sqld = zero on
DESCRIBE OUTPUT) with dynamic output parameters, you must describe it for
output:
DESCRIBE OUTPUT Dynamic1 USING SQL DESCRIPTOR SqldaOut
If only dynamic input parameters are present, the appropriate data buffer or host
variables must be loaded with the values of any dynamic parameters. Then if the
statement is not a query, it can be executed, as in this example using a data buffer:
EXECUTE Dynamic1 USING SQL DESCRIPTOR SqldaIn
However, if the prepared statement is an EXECUTE PROCEDURE statement with multiple
row result sets (sqlmproc = non-zero) and dynamic input and output parameters
execute it as follows:
EXECUTE Dynamic1 USING SQL INPUT DESCRIPTOR SqldaIn
and OUTPUT DESCRIPTOR SqldaOut