Take your SQL and validate that a simpler query works then build it up.
For example the original:
SELECT DISTINCT PRQ.RPT_QUEUE_ID, LRF.FORM_DESC,CU.USER_FULLNAME AS "Scheduled_By", PRQ.SCHEDULED_ON, PRQ.EXECUTION_DATE,
MAX(PRS.TOTAL) AS "Total_Case_Count" , ROUND((MAX(PRS.END_DATE) - MIN(PRS.START_DATE)) * 3600,2) AS "Run_Time_in_Sec"
FROM ARGUS_APP.PER_RPT_QUEUE PRQ,
ARGUS_APP.PER_RPT_STATUS PRS,
ARGUS_APP.LM_REPORT_FORMS LRF,
ARGUS_APP.CFG_USERS CU
changed to (take away the date fieldsand max and min, if the query runs dbtail, then add on fields one by one. What is the native DB date field format? :
SELECT DISTINCT PRQ.RPT_QUEUE_ID, LRF.FORM_DESC,CU.USER_FULLNAME AS "Scheduled_By",
MAX(PRS.TOTAL) AS "Total_Case_Count"
FROM ARGUS_APP.PER_RPT_QUEUE PRQ,
ARGUS_APP.PER_RPT_STATUS PRS,
ARGUS_APP.LM_REPORT_FORMS LRF,
ARGUS_APP.CFG_USERS CU
... View more