| Syntax 
   define external counter function SQLbindparameter
     (  read-only SQL_handle_type StatementHandle,
        value counter ParameterNumber,
        value counter InputOutputType,
        value counter ValueType,
        value counter ParameterType,
        value counter ColumnSize,
        value counter DecimalDigits,
        read-only SQL_array_type ParameterValue,
        value counter BufferLength,
        read-only SQL_array_type StrLen_or_Ind )
 Purpose
 
 Links a variable to a parameter marker in an SQL statement. 
 Input arguments:
 StatementHandle.
ParameterNumber. The parameter number, ordered sequentially in increasing parameter order, starting at 1.
InputOutputType. The type of parameter. The following values are allowed: 
SQL_PARAM_INPUT, SQL_PARAM_INPUT_OUTPUT, and SQL_PARAM_OUTPUT. 
ValueType. The C data type of the parameter. 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
ParameterType. The SQL data type of the parameter. The following values are allowed: 
SQL_UNKNOWN_TYPE
SQL_CHAR
SQL_NUMERIC
SQL_DECIMAL
SQL_INTEGER
SQL_SMALLINT
SQL_FLOAT
SQL_REAL
SQL_DOUBLE
SQL_DATETIME
SQL_VARCHAR
SQL_TYPE_DATE
SQL_TYPE_TIME
SQL_TYPE_TIMESTAMP
SQL_LONGVARCHAR
SQL_BIT
SQL_TINYINT
SQL_BIGINT
SQL_BINARY
SQL_VARBINARY
SQL_LONGVARBINARY
SQL_INTERVAL_MONTH
SQL_INTERVAL_YEAR
SQL_INTERVAL_YEAR_TO_MONTH
SQL_INTERVAL_DAY
SQL_INTERVAL_HOUR
SQL_INTERVAL_MINUTE
SQL_INTERVAL_SECOND
SQL_INTERVAL_DAY_TO_HOUR
SQL_INTERVAL_DAY_TO_MINUTE
SQL_INTERVAL_DAY_TO_SECOND
SQL_INTERVAL_HOUR_TO_MINUTE
SQL_INTERVAL_HOUR_TO_SECOND
SQL_INTERVAL_MINUTE_TO_SECOND
SQL_UNICODE
SQL_UNICODE_VARCHAR
SQL_UNICODE_LONGVARCHAR
SQL_UNICODE_CHAR
ColumnSize. The size of the column or expression of the corresponding parameter marker.
DecimalDigits. The decimal digits of the column or expression of the corresponding parameter marker.
ParameterValue. The parameter data.
BufferLength. The size of a single element in ParameterValue.
StrLen_or_Ind. The length or indicator of data elements in ParameterValue.
 |