Link to this page
Print this page
Parent topic
:
SQL support
SQL support
Dynamic SQL management
Explains how to execute and manage SQL statements at runtime.
Understanding dynamic SQL
PREPARE (SQL statement)
Prepares an SQL statement for execution.
EXECUTE (SQL statement)
This instruction runs an SQL statement previously prepared.
FREE (SQL statement)
Releases the resources allocated to a prepared statement.
EXECUTE IMMEDIATE
Performs a simple SQL execution without SQL parameters or result set.