Begin detailed description.

This figure shows an example result set with three columns and the six arrays that are used to retrieve this data.

One row of example data is depicted for the result set. The following table indicates the data type and example data for each column.
Column name Data type Example data
A INTEGER 10
B CHAR(3) XYZ
C CHAR(10) Abcde
After a fetch, the example data from each column appears in the six arrays as the following table indicates.
Array Example data Description
SQLINTEGER A[n] 10 Contains data from column A.
SQLINTEGER La[n] 4 Contains the data length from column A.
SQLCHAR B[n][4] XYZ Contains data from column B.
SQLINTEGER Lb[n] 3 Contains the data length from column B.
SQLCHAR C[n][11] Abcde Contains data from column C.
SQLINTEGER Lc[n] 5 Contains the data length from column C.

End detailed description.