| 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. 
 |