I'm using unsupported IngresII 2.0 with Reliant UNIX 5.43 and infodb is
not reporting all 72 databases known to accessdb.  Infodb gets to 26
and then falls over, as follows:
infodb | grep Collation | wc -l

I have a DTS job to pull data out of an ingres database. When I run
this job manually through enterprise manager, it runs perfectly, when I
schedule it, it fails.
I've found a Microsoft KB on a similar problem that didnt help.

I'm trying to install the latest open source version on RedHat running
inside of VMWare. (Long story ;)  ), but the install is failing. I'm sure
it's a problem with VMWare, not Ingres, since the same install runs on a
native RH box. (Actually, it's Fedora Core 5.)

I am running ingres 2.6+sp2 on Tru64 5.1b pk5.
After an application upgrade my db has ground to a halt.
My fault finding has found that if I unloaddb / destroydb / createdb /
reloaddb, the db runs perfectly.

Hi Jared,
Stepping back a moment I would like to understand why you are exploring the
use of ALTER TABLE....ADD... in the first place. There is a major limitation
with columns that are added this way in that they have to be NULLABLE and

Hi Erwin,
Do these random queries have a table in common?
Did this problem start shortly after a run of optimizedb?
If yes to both then you could try dropping and recreating the stats on that

I'm doing some research on Ingres, to try and get a better
understanding of the market. I have a question. Please don't take it
the wrong way, because I really am trying to get a better understanding
of Ingres's niche in the overall database market. Ok. Here's my

I've been trying to set a timeout for my Ingres queries, but I can't
seem to get the necessary statements through the CA JDBC driver.
I'm using the CA driver (ca.edbc.jdbc.EdbcDriver), from a java channel
running inside uPortal, to connect to Ingres SPARC SOLARIS Version II

I'm running IngresII2.6/0305 patch 11481 on a DEC Alpha.
I'm trying to convert an SQL-92 compliant installation to non-SQL92.
To do this, I have to unload all the databases, in ascii, and then blow
away the current installation, create the new installation and then reload

Check the SQL Server Agent account has permission to access your database.
Running from enterprise manager could run using a different user context to
scheduling via SQL Agent depending on the accounts configured to run the SQL
Server Service and that of the SQL Agent..

Sharing the good news as instructed.
-------- Original Message --------
Hello all,
I'm pleased to announce that we have completed our update of the Ingres

       I'm trying to extract an ingres date in the format  yyyymmdd.  I've
tried the following:
select varchar(date_part('year','today'))+
      varchar(date_part('month','today'))+

I'm trying to run a bit of SQL that does an "ALTER TABLE". I'm getting
the error message about a table size less than 2k.
The error message is: Info: ERROR '50000' 0x6009d: 'Alter Table
ADD/DROP column support for pages greater than 2k only.'

Try simple:
select varchar(date_part('year','today'))+        
right('0'+varchar(date_part('month','today')), 2)+
right('0'+varchar(date_part('day','today')), 2)  

I'm seeing an index called k_(table_name). For instance the accounts
table has an index called k_accounts. Since I didn't create this index,
I assume it is an Ingres system index? Is that correct?
Anyone know what the k stands for? :)