search cancel

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

book

Article ID: 54180

calendar_today

Updated On:

Products

RC Compare for DB2 for z/OS Database Analyzer for DB2 for z/OS Fast Unload for DB2 for z/OS Fast Check for DB2 for z/OS Fast Index for DB2 for z/OS Rapid Reorg for DB2 for z/OS CA Distributed Database Management CA Database Analyzer for DB2 for Oracle Database Analyzer (IMS Tools) Mainframe Configuration Manager for IMS for z/OS IMS TOOLS - MISC Compress Data Compression (IMS Tools) Database Analyzer for IMS for z/OS Database Copier for IMS for z/OS Database Organizer for IMS for z/OS Mainframe Extended Terminal Manager (IMS Tools) High Performance Recovery for IMS for z/OS Database Organizer (IMS Tools) Mainframe Program Restart Manager for IMS for z/OS Secondary Index Builder for IMS for z/OS Secondary Index for IMS for z/OS

Issue/Introduction

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

Environment

Release:
Component: DBA