sqldynexec() — Execute a Dynamic SQL Statement
Executes a prepared dynamic ESQL statement. This function supports both the dynamic EXEC SQL OPEN... and EXEC SQL EXECUTE... statements.
This function returns normalized values. For more information, see the function return values in the "General Diagnostics" section in this chapter:
sqln
A pointer to the request handle that a previous call to
sqldynprep()
returns. For more information on request handles, see the "SQL Request Handles" section.psqlda
A pointer to an SQLDA_T structure that contains the data values for any dynamic parameter markers in the statement.
NOTES
EXAMPLE
- This function executes a statement prepared by a call to
sqldynprep()
. If there are parameter markers in the statement, supply the data values in thepsqlda
argument.- If the prepared SQL statement is not a cursor specification, you can call
sqldynexec()
repeatedly to execute the statement multiple times, supplying different values for parameter markers if any are present. If the prepared SQL statement is a cursor specification, you can repeatedly execute the statement, but you must callsqldynclose
(sqln
, SQL_STMTCLS) before each call tosqldynexec()
.This example prepares and executes a cursor specification without any parameter markers:
SEE ALSO
sqldynclose() — Close an SQL Statement, sqldynprep() — Prepare a Dynamic SQL Statement, and sqlrequest() — Execute a Static ESQL Statement for executing static ESQL statements.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |