DQBATCH RC=08 when DQ093E - NO ROW FOUND

Products

• Datacom
• Datacom/DB
• Datacom/AD

Issue/Introduction

A DQBATCH job ends with RC=08  when no record matches the WHERE criteria.

 DQ093E - NO ROW FOUND                                       
 RC=14-048,CMD=QEXEC,SQLRC=0100,ERRPGM=texpRead,ERRD3=596-048

Is there a way to make the DQBATCH job end withRC=0 or 4 when no record is found? 

 

Environment

Release : 15.1

Component : Dataquery for CA Datacom

Resolution

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.

Additional Information

See documentation section DBSQLPR Utility--Execute SQL through Datacom/DB