Say an article is posted on c.d.i, x-psoted to c.d.o, as in the
recent "is Oracle technically better than Ingres ?" thread. Will
a reply from behind the info-ingres gateway be propogated to
c.d.i and c.d.o, or just c.d.i? If only the latter, then comment

Hi Goutam,
A very good place about database reverse engineering:
http://www.info.fundp.ac.be/libd/rubrique.php3?id_rubrique=4
I suggest your customer to liaise with Jean-Luc Hainaut,

This insert is causing a table scan locking the destination table for
several minutes. Of course the query was designed and tested when
carton_scan was much smaller.  Any ideas?  Do I need to make a temporary
table, then insert?

I would be interested by any experience from people using Ingres
servers on Linux.
What Linux distribution and version are they ?
Is it a cluster and, if so, which software is currently used ?

We see frequently E_DM9042_PAGE_DEADLOCK errors on a hash table
(unique keys)  with 1 record.  The table is meant for holding an
incremental key for determining the key of another table.
The 1 record table is heavily accessed by a lot of sessions in a small

I need to select rows from a table in the same order of their insert
in.
I supposed (erroneously) if not use orderby clause will be sufficient.
But doesn't work.

I'm selecting from a char field in a table, the char column holds numeric
data that I want to convert to an integer.
Can someone explain how the value returned changes from 58 to 57 below;
(caused by the use of 'int4')

There have been questions about how to subscribe/unsubscribe now the AMS
is using Mailman software to maintain the list. You can use either the
web interface at:
http://lists.ams.org/mailman/listinfo/info-ingres

I did a full Ingres 2.6 installation a few months ago. To date all
clients have been running locally, and everything has been working fine.
I am now trying to run a client from a remote machine with the same
installation, however I have now discovered that in each installation

Is anyone aware of an oledb connector to Ingres 2.6 ?  I would prefer to use
one over odbc/jdbc.
Has anyone connected to an Ingres DB from C# and if so what did you use ?
Thanks

At the moment we have an ABF/Ingres application (II 2.5/011 -
hpb.us5/00) on a HP-Unix 11 server. From a PC we connect with
Reflection to this server and start our application.
Is it possible to use Upfront for giving our application a GUI look

The question is whether a report created in OpenROAD Reporter tool may
be called from an OpenROAD script and is it possible to pass
parameters from the script instead of entering their values in dialog
window? I cannot find an answer in the OpenROAD documentation. Any

'Morning all.
I have been coaxed out of the undergrowth and into the open to look at an
Ingres NET problem, from which I would normally run screaming back into the
bushes.  Unfortunately I have nowhere to hide on this one.

I work on a XP client with OpenRoad 4.1
II_TIMEZONE_NAME=EUROPE_CENTRAL
h_date = DATE('29/03/2004');
h_res_date = h_date - '1 days';

In ingres table say tab1 I have varchar(40) column in which I get data
as "ABCD|123|UITCG|N". When I am selecting from the tab1 we want to
convert the above data as "ABCD\|123\|UITCG\|N".
Please let me know the way of achieving this.