Re: [sqr-users] error in SQR

["Prasanna Menta" <pmenta@umuc.edu>]

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