I have this sql statement that runs fine in strsql, but when i put it in my rpg program it gives me error 42703, i cant figure this out it is driving me nuts. The job log tells me
Cursor CURSOR1 already open or allocated.
Column or global variable AMT_PAID not found.
Cursor CURSOR1 already open or allocated.
Column or global variable AMT_PAID not found.
PHP Code:
DECLARE CURSOR1 CURSOR FOR
SELECT CNDESC AS CLASS_NAME,CNCODE AS CLASS_NUMBER,
MONTH(WSDATE) AS MONTH, COUNT(DISTINCT(WSCNUM)) AS WORKSHOPS,
COUNT(WKSNUM) AS CLIENTS,(COUNT(DISTINCT(WSCNUM)) * CNRATE)
AS amt_paid
FROM CAWRKS JOIN CAWKSD
ON WKCA#=WSCA# AND WKCNUM=WSCNUM
JOIN CACNM
ON CNCODE=WSCNCO
JOIN CABINV
ON WSINV=CBINVA
WHERE WSDATE BETWEEN :FDATE AND :TDATE
AND CBSTAT='Y'
GROUP BY CNDESC,CNCODE,MONTH(WSDATE),CNRATE
ORDER BY CNCODE,MONTH(WSDATE);
Comment