This article provides Open ESQL SQLCODES additions and corrections.
Problem:
Receiving -19519 SQLCODE when running with Microsoft SQL Server 2005, and cannot resolve code with SQL Server documentation.
Resolution:
Try the following:
-811 (checksingleton, multiple rows)
-16930 Cursor is not positioned on a row (WCO, no data)
-16931 Cursor is not positioned on a row (WCO, no rows available)
-19085 Invalid ODBC catalog query (QUERY x not supported)
-19101 Statement too long
Too many host variables specified
(too large for buffer...)
-19103 Illegal X value Y
Non-numeric X value Y
(SET LOGINTIME, SET QUERYTIME)
-19199 ESQL Keyword(s) detected in PREPARE/EXECUTE IMMEDIATE statement
-19313 Too few host variables (specified?) NOT USED!
-19413 Data overflow occurred during decimal conversion
-19414 Numeric data truncation occurred (fixed typo)
-19425 NULL value returned but no indicator variable supplied
-19501 No cursor declared. NOT USED!
-19508 Cursor is not positioned on a row (WCO, no effect, NIST error)
-19514 Cursor is not prepared
-19516 Cursor already open
-19519 Cursor not open
-19520 Connection does not support HOLD cursors
-19701 NULL connection name
Connection X not found (e.g. disconnect X)
-19702 Connection name not found
Attempt to close nonexistent connection
(set connection X, disconnect non existent, statement with no connection)
-19703 Could not make connection.
-19707 Duplicate connection name (e.g. 2nd connect to existent connection name)
-19804 Illegal data (converting USAGE DISPLAY to string)
-19822 Improperly initialised User SQLDA
-19955 Text not found in X section Y (SET OPTION ...)
-19957 Access Plan or statement text not found
Incident Number: 2267092
#MFDS
#EnterpriseDeveloper

