Skip to main content

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

Old KB# 14711

#MFDS
#EnterpriseDeveloper