Syntax
define external counter function SQLGetData
( read-only SQL_handle_type StatementHandle,
value counter ColumnNumber,
value counter TargetType,
modifiable stream TargetValue,
value counter BufferLength,
modifiable counter StrLen_or_Ind )
Purpose
Retrieves data for a single column in the result set. It can be called many times to retrieve variable-length data in parts.
Input arguments:
- StatementHandle.
- ColumnNumber. The number of the result set column. Columns are numbered in increasing column order starting at zero (column 0 is the bookmark column), if bookmarks are available. Otherwise, column numbers start at 1.
- TargetType. The C data type of the result data. The following values are allowed:
- SQL_C_DEFAULT
- SQL_C_NUMERIC
- SQL_C_CHAR
- SQL_C_LONG
- SQL_C_SHORT
- SQL_C_FLOAT
- SQL_C_DOUBLE
- SQL_C_DATE
- SQL_C_TIME
- SQL_C_TIMESTAMP
- SQL_C_TYPE_DATE
- SQL_C_TYPE_TIME
- SQL_C_TYPE_TIMESTAMP
- SQL_C_INTERVAL_YEAR
- SQL_C_INTERVAL_MONTH
- SQL_C_INTERVAL_DAY
- SQL_C_INTERVAL_HOUR
- SQL_C_INTERVAL_MINUTE
- SQL_C_INTERVAL_SECOND
- SQL_C_INTERVAL_YEAR_TO_MONTH
- SQL_C_INTERVAL_DAY_TO_HOUR
- SQL_C_INTERVAL_DAY_TO_MINUTE
- SQL_C_INTERVAL_DAY_TO_SECOND
- SQL_C_INTERVAL_HOUR_TO_MINUTE
- SQL_C_INTERVAL_HOUR_TO_SECOND
- SQL_C_INTERVAL_MINUTE_TO_SECOND
- SQL_C_BINARY
- SQL_C_BIT
- SQL_C_SBIGINT
- SQL_C_UBIGINT
- SQL_C_TINYINT
- SQL_C_SLONG
- SQL_C_SSHORT
- SQL_C_STINYINT
- SQL_C_ULONG
- SQL_C_USHORT
- SQL_C_UTINYINT
- SQL_C_BOOKMARK
- SQL_C_VARBOOKMARK
- SQL_C_TINYINT
- SQL_C_VARBOOKMARK
- SQL_ARD_TYPE
- SQL_C_DEFAULT
- BufferLength. The maximum length of TargetValue.
Output arguments:
- TargetValue. A pointer to the buffer in which to return the data.
- StrLen_or_Ind. The length of data available for return, or the data indicator value (SQL_NULL_DATA or SQL_NO_TOTAL).
|