ESP history report receiving 4476 SQL Error from Workstation

Products

• ESP Workload Automation

Issue/Introduction

SQL Errorcode=-4476 trying to generate a report (using the DB2 Report Server) in the ESP WorkStation.   

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

Cause

This ErrorCode indicates that the result is empty or DB2 does not understand the request.

Resolution

When using the Workstation to generate a report, the syntax is:  

select jobname,rdrondate 
from prod.esp_job_hist 
order by jobname

Do not code REPORT, SQL, and ENDR.