Retrieve DB2 SQLCA Data › External Action Blocks

External Action Blocks

CA Gen also provides the source code for an External Action Block (EAB) that allows applications to retrieve the SQLCODE and other data from the SQLCA after one of these WHEN DATABASE statements executes. This source code is located in the same CA Gen CEHBSAMP used for user exits. However, because it functions as an External Action Block, two more steps are required to install it:

• Define and package the External Action Block in your application model.
• The code must be precompiled to ensure that the correct SQLCA definition is included.