The use of SQLCODE to retrieve the internal Mimer SQL return code for an exception has been replaced by the use of SQLSTATE and GET DIAGNOSTICS with the NATIVE_ERROR option, see Run-time Errors, in Mimer SQL.
For compatibility reasons, return codes can still be retrieved in SQLCODE, as in earlier versions of Mimer SQL. Mimer SQL will assume the existence of an SQLCODE variable in the application if no INCLUDE SQLCA statement is found and neither SQLSTATE nor SQLCODE is declared between BEGIN DECLARE SECTION and END DECLARE SECTION.
The values of SQLCODE are the same as the values for the internal Mimer SQL return codes described in Return Codes.
Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40