by Hi Everyone,
I need some help on a problem that I encountered recently. On a VMS
machine I was running an application that had some embedded Ingres
SQL Select statements. The actual statements were as following:
SELECT COUNT(*) FROM EMPLOYEES;
SELECT COUNT(DISTINCT ENAME) FROM EMPLOYEES;
While the first statement returned data back to the application, the
second statement(with count(distinct ename)) returned an error message
indicating that no grant or grant equivalent statement was given to the
table employees.
It actually did not matter which statement executed first. The error
message always went with the select statement with "count(distinct
ename)" clause. I used a de* on VMS to check the preparation and
description processes for both select statements, and could not find out
any difference and they were ok. The odd thing was that both statements
ran ok in the interactive Ingres SQL environment.
Could some one on the net point to me where the problem could be? Any
help will be appreciated. Thanks in advance!
Hong Wang