Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!usc!ucsd!pacbell.com!pacbell!rtech!squid!robf
From: robf@squid.rtech.com (Robert Fair)
Newsgroups: comp.databases
Subject: re: need help with INGRES ESQLC  inquire_ingres  stmt
Message-ID: <5767@rtech.Ingres.COM>
Date: 4 Sep 90 12:41:08 GMT
Sender: news@rtech.Ingres.COM
Reply-To: robf@squid.Ingres.COM (Robert Fair)
Distribution: na
Organization: Ingres Corporation, Alameda CA 94501
Lines: 29


beverly@ai.cs.wisc.edu (Beverly Seavey (-Kung)) has problems using the
ESQL INQUIRE_INGRES statement, getting a syntax error. The problem is
actually clear in the posting:

>I copied the 2 lines out of version 6 documentation, though we are running
>some version 5. I have included the SQLCA #include.

In Ingres 5.0, the normal way to get status information in ESQL was 
through the standard SQLCA structure or using COPY SQLERROR, so there
was no  INQUIRE_INGRES statement for ESQL back then.
(In 5.0 INQUIRE_EQUEL/INGRES was used by Embedded QUEL and ABF/4GL 
 as a way to get status information, since these languages didn't have 
 an SQLCA)

In Ingres 6.X, INQUIRE/SET_INGRES was added to ESQL for those who prefer
it to the SQLCA - as well as adding support for new features which didn't
fit in the SQLCA (transaction use, DBMS messages, session ids etc)

There are many changes/new features in Ingres 6.X ESQL, from Dynamic SQL 
through Select loops, so its probably not a good idea trying to 
use Ingres 5.0 with 6.X manuals.

Robert Fair
Premium support group
Ingres Corporation, NJ

Standard disclaimer: This posting expresses personal opinions only, and in
no way represents Ingres Corp,.