Non-Zero SQL Code on User Condition

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

Description

What happens to the extract procedure processing action procedures with user defined conditions if a user defined condition SQL statement encounters a non-zero SQL Code?

Solution

If the user defined condition SQL statement encounters a non-zero SQL Code, the process will continue but the object being processed will be rejected and the actual SQL error will be displayed in the PTIMSG DD of the batch job.