How to obtain SQL Error Code?

Products

• Gen
• Gen - Workstation Toolset
• Gen - Host Encyclopedia
• Gen - Run Time Distributed

Issue/Introduction

Custom error handling to capture DB2 exception errors from within an action block.

When using the Database Exception When Database Error, is there a way inside the action diagram to obtain the SQL Error Code?

Environment

z/OS Host Encyclopedia and z/OS Implementation Toolset

Resolution

The sample code is in CEHBSAMP(GETXDBSQ). The developers can use it to create their own EAB to be called from an action diagram.