SQLExecDirect (core level only)
SQLExecDirect executes a preparable statement by using the current values of the parameter-marker variables if any parameters exist in the statement.
SQLExecDirect is the fastest way to submit an SQL statement for one-time execution.
The following
table describes the SQLSTATE and error values for SQLExecDirect.
| SQLSTATE | Error value | Error message |
|---|---|---|
| 01000 | -11001 | General warning |
| 01004 | -11003 | Data truncated |
| 01006 | -11004 | Privilege not revoked |
| 01S03 | -11008 | No rows updated or deleted |
| 01S04 | -11009 | More than one row updated or deleted |
| 07001 | -11012 | Wrong number of parameters |
| 07S01 | -11014 | Invalid use of default parameter |
| 08S01 | -11020 | Communication-link failure |
| 21S01 | -11021 | Insert value list does not match column list |
| 21S02 | -11022 | Degree of derived table does not match column list |
| 22003 | -11025 | Numeric value out of range |
| 22005 | -11026 | Error in assignment |
| 22008 | -11027 | Datetime field overflow |
| 22012 | -11028 | Division by zero |
| 23000 | -11030 | Integrity-constraint violation |
| 24000 | -11031 | Invalid cursor state |
| 34000 | -11034 | Invalid cursor name |
| 37000 | -11035 | Syntax error or access violation |
| 40001 | -11037 | Serialization failure |
| 42000 | -11038 | Syntax error or access violation |
| S0001 | -11053 | Base table or view already exists |
| S0002 | -11054 | Base table not found |
| S0011 | -11055 | Index already exists |
| S0012 | -11056 | Index not found |
| S0021 | -11057 | Column already exists |
| S0022 | -11058 | Column not found |
| 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 |
| S1109 | -11089 | Invalid cursor position |
| 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 |