Filter
Top Products
SQLN
SQLN indicates the maximum number of the dynamic parameter specifications that can be written or the maximum
number of the select column list items that can be written. SQLN therefore determines the maximum number of
elements of array SQLVAR.
SQLD
SQLD determines the number of valid elements of array SQLVAR.
Executing a output DESCRIBE statement specifying an SQLDA structure when the prepared statement contains
select column list items returns the number of select column list items to SQLD.
Executing an input DESCRIBE statement specifying an SQLDA structure when dynamic parameter specifications are
written in the prepared statement returns the number of dynamic parameter specifications to SQLD.
SQLVAR
SQLVAR is an array that stores various kinds of information for dynamic parameter specifications or select column list
items.
Information for this array must be set before an SQL statement is executed for a dynamic parameter specification. An
SQL statement in which n dynamic parameter specifications are written is executed as a prepared statement based
on the information stored in SQLVA[0] to SQLVAR[n-1].
Information for this array must be set before an SQL statement is executed for a select column list. If the SQL
statement in which n select column lists are written is executed as a prepared statement, data is stored in the data
buffers specified in SQLVAR[0] to SQLVAR[n-1] after the SQL statement has been executed.
Item descriptor area SQLVAR consists of the items listed in the following table.
The table below shows the correspondence between the TYPE values (data-type codes) of the SQLDA structure and
SQL data types.
136