Was this helpful?
Effect on Embedded SQL Procedures
In ABF or Vision applications, the user-defined error handler affects all frames and 4GL procedures in the application. However, any embedded SQL procedures that you include can use a different method of error handling, involving whenever statements and a communications area known as the SQLCA. See the SQL Reference Guide for more information about the SQLCA and the whenever statement.
When an ABF or Vision application calls an embedded SQL procedure that uses the SQLCA, your user-defined error handler is temporarily turned off. When the embedded SQL procedure returns control to ABF or Vision, your user-defined error handler resumes operation.
Last modified date: 11/09/2022