I would like to get the rows with the maximum number rows of each
group of fields.
For example, I have a table called "sometable", with columns "x" and
"y". It looks like this:

Does anyone know if it's possible to use multi-transaction SQL
statements in the Visual SQL too for R3?  I'm running it against a
backend database that is running on II 2.0.  Also, is it possible to cut
and paste the result set?  It would be a shame if both these features

I am in dark. I know very little about ingres. But I have got a
project ahead. There is an old Ingres II database in unixware 7.1.1,
and I need to access the database from a windows NT based web server.
I have options to choose the web server either IIS or Apache, but

Running II 2.6/0305 9su4.us5/00), patch 10307. Found the following lines in
the II_DBMS_LOG file and was wondering if anyone could provide some info:
!Thu Oct 28 11:54:46 2004 [6912,03B9A180] physsrc >>>>> set TRACE POINT
DM102

I wrote a small program to modify the Ingres config file in order
to implement a poor man's version of a replicator.
Pretty straight foward. One thing I do is modify all directory
path names with a new one of the same lenght. That's because each

Unfortunately I wasn't able to make it to the IUA conference earlier in the
week, but I've been hearing fragments of a story about someone who claims to
have taken the Ingres source and managed to graft a PL/SQL clone onto it in
a matter of a few days.

Anybody was able to compile Ingres r3 under SCO Open Server 5.0.6 and is
willing to share the experience ?
On a different note is the open source Ingres license similar with other
open source licenses ? In my understanding you can use the SW in your

on the current site I am on - i have run into something I cannot
explain.
The site has multiple database locations for one file. But they are on
the same disk.

I have a replica standby ingres server.
My DR strategy is...
Copy over ckp, jnl and dmps once the checkpoint is completed each night.
then shutdown ingres, mv the files to the appropriate areas start ingres and

Is it possible to connect to Ingres R3 Net server from
old windows 6.4/04 Net client? After instalation of R3
(Windows Beta1) I have try to connect from old client
but I have got:

Hi Gang,
We're in the process of adding more storage to our system and I'm trying
to come up with a sensible use of the disks.
I'm putting ckp, dmp & jnl together on a couple of disks and spreading

Good morning,
I'm going to purchase an Advantage Ingres Entreprise 2.6 database + 1Y
license; what will happen after 1 year from installation? will the
database still work?

     All accesses will be denied during ckpdb was running, right?
It will take one hour to do ckpdb for our database and it is
unacceptable if access  was rejected during the period.
     Would you mind telling me how do you backup your database without

just a question about iislave (yes we still use them because
the problems with HPUX and native threads).
We have configured n slaves per dbserver ( with II_NUM_SLAVES ),
and I will check, whether the number is ok or not.

How do I get myself removed from this list server?
Thanks,
Bill