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