What happens to PDA processing if my user defined action condition gets a non zero sqlcode?

Document ID : KB000054180
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

If I create my own action condition and select this for my Action Procedure. When I submit the extract that has the action procedure tied to it and the action condition SQL generates an SQLCODE that is non zero. What happens to the extract job.

Solution:

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 you should execute your SQL outside of PDA to see why the sqlcode is being returned and correct the sql if necessary.

Please note: The PDA Reference Guide does state:

"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."