Syntax
define external counter function sqlbindcol
( read-only SQL_handle_type StatementHandle,
value counter ColumnNumber,
value counter TargetType,
read-only SQL_array_type TargetValue,
value counter BufferLength,
read-only SQL_array_type StrLen_or_Ind )
Purpose
Binds application data buffers to columns in the result set.
Input arguments:
- StatementHandle.
- ColumnNumber. The number of the result set column. Columns are numbered in increasing column order, starting at 0 if bookmarks are available. (Column 0 is the bookmark column.) 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
- TargetValue. The variable that will receive the fetched data.
- BufferLength. The length of the data buffer, in bytes.
- StrLen_or_Ind. The variable that will receive the length/indicator of the column data.
|