When the prepared statement corresponding to SQL statement identifier STM1 is as follows, SQL descriptor area
DESC1 will have the following contents:
GET DESCRIPTOR statement
The GET DESCRIPTOR statement fetches information set in the SQL descriptor area to the host variable. The data
type of the host variable must match the data type of the corresponding get identifier.
An example of fetching the number of dynamic parameter specifications to host variable varcount is shown below.
An example of fetching the contents of the dynamic parameter specification set in the SQL descriptor area to host
variables vartype, varleng, and varoctet is shown below. The element number of the item descriptor area to be
acquired should be the value set in varwcount.
172