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.
Table 1. Using a system-descriptor area to execute dynamic SQL statements
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