CHAPTER 10 Database Error Messages
927
Wrong number of values for INSERT
Item Value
SQLCODE -207
Constant SQLE_WRONG_NUM_OF_INSERT_COLS
SQLSTATE 53002
Sybase error code 213
ODBC 2 State 21S01
ODBC 3 State 21S01
The number of values you are trying to insert does not match the number of
columns specified in the INSERT statement, or the number of columns in the
table if no columns are specified.
Wrong number of variables in FETCH
Item Value
SQLCODE -264
Constant SQLE_WRONG_NUM_OF_FETCH_VARIABLES
SQLSTATE 42W26
Sybase error code 553
ODBC 2 State S1002
ODBC 3 State 07009
You specified a number of variables in a FETCH statement that does not
match the number of select list items.
Probable cause
Probable cause