SQLPutData (level one only)
SQLPutData allows an application to send data for a parameter or column to the driver at statement execution time.
This function can send character or binary data values in parts to a column with a character, binary, or data-source-specific data type (for example, parameters of SQL_LONGVARBINARY or SQL_LONGVARCHAR).
The
following table describes the SQLSTATE and error values for SQLPutData.
| SQLSTATE | Error value | Error message |
|---|---|---|
| 01000 | -11001 | General warning |
| 01004 | -11003 | Data truncated |
| 07S01 | -11014 | Invalid use of default parameter |
| 08S01 | -11020 | Communication-link failure |
| 22001 | -11023 | String data right truncation |
| 22003 | -11025 | Numeric value out of range |
| 22005 | -11026 | Error in assignment |
| 22008 | -11027 | Datetime-field overflow |
| S1000 | -11060 | General error |
| S1001 | -11061 | Memory-allocation failure |
| S1008 | -11065 | Operation canceled |
| S1009 | -11066 | Invalid argument value |
| S1010 | -11067 | Function-sequence error |
| S1090 | -11071 | Invalid string or buffer length |
| S1T00 | -11094 | Time-out expired |
Important: An application can use SQLPutData to
send sections of character C data to a column with a character, binary,
or data source-specific data type or to send binary C data to a column
with a character, binary, or data source-specific data type. If SQLPutData is
called more than once under any other conditions, it returns SQL_ERROR
and SQLSTATE 22003 (Numeric value out of range).