Advanced Database Feature Guide


Retrieving Diagnostic Information

Diagnostic information can be retrieve at any time by asking an object for its call status. However, a call status is more commonly obtained from the UtyDB2signal that is generated when an SQL error occurs.

The call status is a compilation of all the available diagnostic information available about a given SQL error. With it, the application can obtain the SQL error’s state (sqlstate), native error code (sqlcode), and SQLCA. In addition, the call status can also contains zero or more diagnostic messages that can be used to further clarify the error.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]