Help needed on embedded sql statement

Help needed on embedded sql statement

Post by Hong Wa » Thu, 26 Nov 1992 09:05:47

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:

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


1. Need help: Loading Data with C and embedded SQL statements

I'm working on a simple RDB/VMS (using SQL) database for a course I'm taking.

I need to load a bunch of data into the database, and I'm looking for examples
of C programs with embedded SQL statements.  What I need is something fairly
simple (I'm no C guru) that will prompt for the input and then load the values
into the database.

Any code fragments or examples?  Thanks in advance.

2. Object type for a memo field?

3. Need a copy of ANSI standard listing of Embedded SQL statements

4. Help NT & SQL newcomer get started with 6.5 eval

5. HELP: Embedded characters in SQL statement

6. OLE Automation Help !!!

7. NEED HELP WITH SQL SELECT STATEMENT - need to reference cookie info

8. Urgent! Need help on assignment - Embedding SQL

9. I need help using DATE functions in an INSERT in embedded SQL with C

10. embedded SQL: need help

11. Embedded COBOL/SQL Conversion from DB2 to Sybase Info/Help Needed