Begin detailed description.
This figure shows an example result set with three columns and a structure that is 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 structure that is defined as follows:
struct {SQLINTEGER La, SQLINTEGER A,
SQLINTEGER Lb, SQLCHAR B[4],
SQLINTEGER Lc, SQLCHAR C[11];
} buffer[n]; The following table describes
the data that each component of this structure receives.
| Component | Example data | Description |
|---|---|---|
| SQLINTEGER A | 10 | Contains data from column A. |
| SQLINTEGER La | 4 | Contains the data length from column A. |
| SQLCHAR B[4] | XYZ | Contains data from column B. |
| SQLINTEGER Lb | 3 | Contains the data length from column B. |
| SQLCHAR C[11] | Abcde | Contains data from column C. |
| SQLINTEGER Lc | 5 | Contains the data length from column C. |
End detailed description.