SQLSpecialColumns (level one only)
SQLSpecialColumns retrieves information about columns.
SQLSpecialColumns retrieves the following
information about columns within a specified table:
- The optimal set of columns that uniquely identifies a row in the table
- Columns that are automatically updated when any value in the row is updated by a transaction
The following table describes the SQLSTATE and error values
for SQLSpecialColumns.
| SQLSTATE | Error value | Error message |
|---|---|---|
| 01000 | -11001 | General warning |
| 08S01 | -11020 | Communication-link failure |
| 24000 | -11031 | Invalid cursor state |
| S1000 | -11060 | General error |
| S1001 | -11061 | Memory-allocation failure |
| S1008 | -11065 | Operation canceled |
| S1010 | -11067 | Function-sequence error |
| S1090 | -11071 | Invalid string or buffer length |
| S1097 | -11078 | Column type out of range |
| S1098 | -11079 | Scope type out of range |
| S1099 | -11080 | Nullable type out of range |
| S1C00 | -11092 | Driver not capable |
| S1T00 | -11094 | Time-out expired |
| S1C00 | -11300 | SQL_DEFAULT_PARAM not supported |
| 08S01 | -11301 | A protocol error has been detected. Current connection is closed. |
| S1000 | -11310 | Create and Drop must be executed within a ServerOnly Connection |
| S1000 | -11320 | Syntax error |
| S1000 | -11323 | The statement contained an escape clause not supported by this database driver |