Using a system-descriptor area
Use a system-descriptor area to execute SQL statements that contain unknown values.
The following table summarizes the types of dynamic statements
that the remaining sections of this chapter cover.
Purpose of a system-descriptor area | See |
---|---|
Holds select-list column values retrieved by a SELECT statement | Handling an unknown select list |
Holds returned values from user-defined functions | Handling unknown return values |
Describes unknown columns in an INSERT statement | Handling an unknown column list |
Describes input parameters in the WHERE clause of a SELECT statement | Handling a parameterized SELECT statement |
Describes input parameters in the WHERE clause of a DELETE or UPDATE statement | Handling a parameterized UPDATE or DELETE statement |