sindu.sagudam
New User
Joined: 02 May 2007 Posts: 8 Location: mumbai
|
|
|
|
Hi all,
I am trying to execute the following query in my program
EXEC SQL DECLARE SRQL-BLOB-PURG CURSOR WITH RETURN FOR SELECT YEAR,MONTH,COUNT(*) AS IMAGES
FROM (SELECT YEAR(A.T_STMP_UPD) AS YEAR,
MONTH(A.T_STMP_UPD) AS MONTH
FROM S.SREQEST A,S.SRQBLOB B
WHERE A.I_REQ = B.I_REQ) PMT
GROUP BY YEAR,MONTH
ORDER BY YEAR DESC,MONTH DESC
END-EXEC.
This query is running fine in spufi.
But in the program with the cursor it is giving a compilation error as below
MISSING VIEW AND/OR PRIVILEGE FOR:
VIEW NAME -> (
PRIVILEGE TYPE -> SELECT
SYSTEM NAME -> DPA
PROGRAM NAME -> DPA0010B
RC=8
* * *
* * * * * * * * * * * * * * * * * * * * * *
* * * * * * * * * * * * * * * * * * * * * *
PROCESSING COMPLETE, ERRORS FOUND!
CONTACT YOUR DBA FOR ASSISTANCE!
HIGHEST RC=8
* * * * * * * * * * * * * * * * * * * * * *
Kindly let me know is it a problem due to authorization or some problem with the query.
Thanks and Regards,
Sindu. |
|