%XSQL.Exceptionhidden class %XSQL.Exception
%XSQL.Exception This is an exception class for %XSQL processing. It supports SQLCODE, SQLSTATE, as well as conversion of message codes and text from one message domain to another. This is useful for reporting a Cache SQLCODE error as an Informix error code or an SQL Server error code. TODO: The implementation of this class needs to be completed. This is just a shell right now. This is replaced by %SQL.Exception and this class should not be used.
Additional free text information about the error, may be null
SQLCode of this error, may be null
Severity is an indication as to the severity of the error being reported. The value, 0-25, not only provides information, it is a hint to the error processor as to what action to take. For TSQL this means returning control to the current batch or procedure at the point following the statement reporting the error, exiting the current batch or procedure or terminating the connection. TSQL defines severity of 10-19 as transferring to the CATCH block. Cache will exit the current procedure if severity is > 19.