I have a section that populates a C structure 'foo' from a Ingres table
'aTable'....
    someCounter = 0;
##     REPEAT RETRIEVE (

Can anyone tell me why I have to pay more for Ingres support through
Ingres than I did through CA?
Has anyone else found that their support costs have gone up?
Basically we'll be looking at moving from Ingres if this continues.

I have defined a rule on a table. The rule inserts a row into a  second
table whenever a change is made to the 1st one. The rule causes an error
of a duplicate row inserted.
I wanted to pinpoint the error so I set a trace into a log

Me again. Still working on the Rails support for Ingres. This time I'm
trying figure out if Ingres has support for the idea of an offset in a
result set.
In MySql you have LIMIT. (Ingres has FIRST). But in MySql, you can ask

Gang,
It's Friday!  Time for me to look even more stupider
than usual ...
OK, I'm going to quote Roy here:

is it possible, with Ingres II, to write such a query :
select field1, if(field2>25,field3,field4) from table
where the syntax would be if(condition,then,else) ?
Thanks !

Regarding the sqlca.sqlcode in embedded sql what is the following a
test for:
sqlca.sqlcode != 100
I have found the following also:

I hope someone can help with one as we've just spent a whole day trying
to figure out the problem to no avail.
We're trying to connect from a linux box running Red Hat Enterprise
linux 3 update 7 to an Ingres 2.0 database on an AIX platform.  When we

Server OS: SCO OpenServer Release 5.0.5
Client OS: SuSE 10.0 Pro
IngresII 2.0/0001 (sos.us5/00) with Patch 6900
Up until now I was able to access my client's ABF/4GL app from my own SCO

head $II_SYSTEM/ingres/version.rel
II 2.5/0011 (rmx.us5/00)
10421
Reliant UNIX (aka SINIX-Y) 5.43

Ingres Release II 3.0.2 on SuSE Linux 9.3 Professional reports an an
internal error, when trying to execute a query. The query works fine
until the result is larger than 83143 rows.
The query is run from an embedded sql application (C). When I try the

Does anone know where the FRSKEY's are defined?
For example in an OSQ we can define a menu-item as follows:
'Select', KEY FRSKEY5=
{

 We were practicing a recovery test with one of our OpenIngres 2.0
databases. Our checkpoint process includes using Veritas Volume Manager
to do volume snapshots of our Ingres data files during the checkpoint.
When we do the rollforwarddb the snapshot data will be restored to the

In spite of what my kids think, I am a pretty serene and reasonable guy.
But one (of the very few) things that drives me absolutely beserk is having
to install a gigabyte of spurious cack just to get a command-line C compiler
and linker for the Microsoft environment.  Even Visual ...

What does the QUALIFICATION clause do in an ABF select query?
i.e.
   tbl = SELECT prod, qty,  det_code, supp, ord,
         FROM   orders