There are statements that associate the descriptor with a SQL statement and with a cursor associated with the SQL statement. The following list describes dynamic SQL statements for method 4:
Statement |
Description |
|---|---|
allocate descriptor |
Notifies Client-Library to allocate a SQL descriptor. |
describe input |
Obtains information about the dynamic parameter marker in the prepare statement. |
set descriptor |
Inserts or updates data in the system descriptor. |
get descriptor |
Moves row or parameter information stored in a descriptor into host variables, thereby allowing the application program to use the information. |
execute |
Executes a prepared statement. |
open cursor |
Associates a descriptor with a cursor and opens the cursor. |
describe output |
Obtains information about the select list columns in the prepared dynamic SQL statement. |
fetch cursor |
Retrieves a row of data for a dynamically declared cursor. |
deallocate descriptor |
Deallocates a dynamic descriptor. |
For complete descriptions of these statements, see Chapter 10, “Embedded SQL Statements: Reference Pages.”
