Download Informix CLI Programmer`s Manual, Version 2.5

Transcript
SQLExecDirect
SQLSTATE
Error
Description
22012
Division by zero
The argument szSqlStr contained an SQL
statement that contained an arithmetic
expression that caused division by zero.
23000
Integrityconstraint
violation
The argument szSqlStr contained an SQL
statement that contained a parameter or literal.
The parameter value was NULL for a column
defined as NOT NULL in the associated table
column, a duplicate value was supplied for a
column constrained to contain only unique
values, or some other integrity constraint was
violated.
24000
Invalid cursor
state
A cursor was already opened on the statement
handle.
The argument szSqlStr contained a positioned
UPDATE or DELETE statement, but the cursor
was positioned before the start of the result set
or after the end of the result set.
34000
Invalid cursor
name
The argument szSqlStr contained a positioned
UPDATE or DELETE statement, but the cursor
referenced by the statement being executed was
not open.
37000
Syntax error or
access violation
The argument szSqlStr contained an SQL
statement that was not preparable or contained
a syntax error.
40001
Serialization
failure
The transaction to which the SQL statement
contained in the argument szSqlStr belonged
was terminated to prevent deadlock.
42000
Syntax error or
access violation
The user did not have permission to execute the
SQL statement contained in the argument
szSqlStr.
S0001
Base table or
view already
exists.
The argument szSqlStr contained a CREATE
TABLE or CREATE VIEW statement, but the table
name or view name specified already exists.
(3 of 6)
13-114
INFORMIX-CLI Programmer’s Manual