A DQBATCH job ends with RC=08 when no record matches the WHERE criteria.
DQ093E - NO ROW FOUND
Is there a way to make the DQBATCH job end withRC=0 or 4 when no record is found?
Release : 15.1
Component : Dataquery for CA Datacom
There's currently no facility within DQBATCH to change the return code returned to the operating system.
If the SQL statement receives a non-zero return code it will set the return code to 8.
As an alternative you could run the SQL statement using DBSQLPR.
The DBSQLPR in-line command *$ZERO can be used to zero the jobstep return code. However you still cannot select to zero the return code based on specific SQL return codes.
See documentation section DBSQLPR Utility--Execute SQL through Datacom/DB