How to obtain SQL Error Code?
search cancel

How to obtain SQL Error Code?

book

Article ID: 13799

calendar_today

Updated On:

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.