-4476 SQL ERROR Generating Report in CA Workload Automation Workstation.

Products

• ESP Workload Automation

Issue/Introduction

 Set up a DB2 Report Server and I am trying to generate the report in the ESP WorkStation. I get the following SQL Errorcode=-4476. 

This Report SQL is from the Install and Config Guide in the Section on testing the report server. 


REPORT 
SQL select jobname,rdrondate 
from prod.esp_job_hist 
order by jobname 
ENDR 

Environment

Release: ENCWLA00200-11.4-Workload Automation-Restart Option-EE
Component:

Cause

This basically says that this ErrorCode can be returned for an empty result set or DB2 does not understand request.

Resolution

When using Workstation remove the Report and ENDR along with "SQL"