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

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

 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. 

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


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


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