RDBPROD: How To Handle a SQLCODE of -1 in Rdb Applications (Doc ID 65376.1)

Last updated on APRIL 16, 2024

Applies to:

Goal

When an application returns a SQLCODE of -1, more error handling must be performed to understand the cause of the error. A SQLCODE of -1 does not have a specific meaning. In the "SQL Reference Manual", Appendix C, there is a list of SQLCODE values and what their meanings. Additional error trapping can be very helpful in other scenarios as well, and Rdb Support recommends calling SQL_GET_ERROR_TEXT or SQL$SIGNAL any time the returned SQLCODE is less than 0. 

Solution