Re: [sqr-users] error in SQR

[andy kumar <andy_us99@yahoo.com>]

I tried but giving the following error:
(SQR 5528) SQLBase SQLCOM error 1102 in cursor 1:
   Security violation attempting to access
SQL: select NAME  FROM SYSADM.PS_PERSONAL_DATA WHERE EMPLID='6601'
Error at: PS_PERSONAL_DATA
Error on line 17:
   (SQR 3716) Error in SQL statement.

Errors were found in the program file.
SQR: Program Aborting.
Thanks,anand.
 Prasanna Menta <pmenta@umuc.edu> wrote:Try using sysadm.ps_personal_data it 
might resolve the problem.


andy kumar wrote:
> 
> Hi All,
> 
> I tried to run a SQR program from peoplesoft 7.5 HRMS as shown below:
> 
> #include 'setenv.sqc' !Set environment
> Begin-Report
> Do proc1
> End-Report
> 
> Begin-Procedure proc1
> BEGIN-SELECT
> NAME (1,1)
> FROM PS_PERSONAL_DATA
> WHERE EMPLID='6601'
> END-SELECT
> End-Procedure
> 
> Giving error:
> 
> (SQR 5528) SQLBase SQLCOM error 601 in cursor 1:
> Table has not been created
> 
> SQL: select NAME FROM PS_PERSONAL_DATA WHERE EMPLID='6601'
> Error at: PS_PERSONAL_DATA
> 
> Error on line 15:
> (SQR 3716) Error in SQL statement.
> 
> Please help me.
> 
> Thanks,andy.
> 
> ---------------------------------
> Do you Yahoo!?
> Yahoo! Mail Plus - Powerful. Affordable. Sign up now
> 
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org
> http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users


---------------------------------
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users