I am using ODBC connection pooling so that database connections
are reused between different process instances.
The problem I have is that my application creates temporary session
tables that are sometimes not dropped (if the process aborts due to a

Somehow the files/symbol.tbl file was corrupted on one of our client
machines.  It looks like I can just copy a valid file from another
client, and fix 2 values that vary across the clients:
II_GCNre_LCL_VNODE (the machine name) and II_GCNre_PORT.

environment is Ingres II 9808 on Aix 4.3
Installed Ingres II - no problems, am able to start and stop ingres.
Apply patch 9181 and am unable to run any ingres commands (ingstart,
ingstop, ingprenv etc)

I am having dificulty using the EdbcDataSource class.
this code works very happily
      Class.forName("ca.edbc.jdbc.EdbcDriver").newInstance();
      Connection con = DriverManager.getConnection(

Anyone seen this when trying to install EA-Gateway 2.1/9807 + patch n/a on
SUN Solaris Sparc 2.9
Seems to be looking for files that don't exist in the installation (is this
a 32bit vs. 64bit problem?)

Does anyone know if they are still trading?
TIA
************************************************************************
DISCLAIMER

I came across some strange sql error (ingres 2.5).
What can be the cause of it ?
 3> select * from my_view        /* quite complex one */    
    where id_number=100            

We are trying to sort with dynamicaly generated sorting order using:
 EXEC SQL BEGIN DECLARE SECTION;
   char sqlcmd[MAXSQL] = {'\0'};
   char orderstr[76]   = {'\0'};

Does anyone know if ABF will be supported in the next release of Advantage
Ingres?  How long do you think CA will continue to support ABF?
Thanks,
Robin

I'm sure this question has probably been asked before in the past, but here
goes:
I need to dump the contents of a table into a comma delimted file.  How do
I do it so that the trailing spaces from the fields are removed?

II 2.0/0001 (su4.us5/00) patch:8121
I'm looking into backup options for disaster recovery purposes.
I'm thinking of ftp'ing journal files throughout the day to a standby server
- probably every couple of minutes. So when the inevitable happens (the air

Hai Ingres user,
We required one small querry from you. I have one table as follows
Date     Carrcd    Quantity
1/1/2004    10    12.000

Adv Ingres 2.6 + SP2 on Windows OS
Hi Group,
I have a table in database consists of 12 columns. There are 3 columns
of varchar data type namely m_ref, annotation, and remarks of size

Hai Ingres user,
We required one small querry from you. I have one table as follows
Date     Carrcd    Quantity
1/1/2004    10    12.000