freeSQL

The EGL freeSQL statement frees any resources associated with a dynamically prepared SQL statement, closing any open cursor associated with that SQL statement.

Syntax

Syntax diagram for the freeSQL statement
preparedStatementID
An identifier that points to code created through an EGL prepare statement.

Error conditions

After you issue a freeSQL statement, you cannot run the execute, open, or get statement for the prepared SQL statement without reissuing the prepare statement.

No error occurs if the prepared code you reference in the freeSQL statement did not run previously.


Feedback