[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

[sqr-users] error in SQR


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