What happens to Database Analyzer for Db2 processing if a user defined Action Condition gets a non zero SQLCODE

Products

• Database Analyzer for DB2 for z/OS

Issue/Introduction

Submitting a Database Analyzer for Db2 for z/OS (PDA) Extract that has an action procedure tied to it and the action condition SQL generates an SQLCODE that is non zero.
What happens to the PDA Extract job.

Resolution

The PDA process will continue, but the object being processed will be rejected and the actual SQL error will be displayed in the PTIMSG output of the PDA job.
In this case execute your SQL outside of PDA to see why the SQLCODE is being returned and correct the SQL as necessary.

The PDA documentation states:

"You can issue any desired SQL statement and it can include joins, sub-queries, and so on.
The SQL statement must return one field value and it must be numeric. If the value is greater than zero, the condition is considered true. Otherwise, the condition is considered false."