After each embedded SQL statement is executed, error and status information is returned in the SQL Communications Area (SQLCA).
For details of the layout of the SQLCA data structure, see the topic
The SQLCA Data Structure.
Note: The Oracle, Sybase, and Informix versions of the SQLCA all use SQLCODE, SQLERRML, SQLERRMC, and SQLWARN. The sizes and the
positions of these fields can differ among the precompilers.
- OpenESQL
- The SQLCA provided with
Enterprise Developer for use with OpenESQL contains two variables (SQLCODE and SQLSTATE) plus a number of warning flags which are used to indicate
whether an error has occurred in the most recently executed SQL statement.
- COBSQL
- See your database vendor documentation for details on testing the success or failure of a given SQL statement.