Re: [sqr-users] error in SQR

["Larry Roux" <LRoux@syr.edu>]

This usually means
a) the table does not exist or
b) you do not have security to see that table or
c) you ran it against the wrong Database

Being as it is unlikely that PERSONAL_DATA does not exist I would look at b and 
c


******************************
Larry Roux
Syracuse University
lroux@syr.edu
*******************************

>>> andy_us99@yahoo.com 01/24/03 01:13PM >>>

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