Hi Dudes,
   So we turned on the DEBUG option. The code didnt compile!
   We played with mkvalidpw so that the cc put output on STDOUT and that s
   when we found out that this code really looks like it aint going to work

I want to know Advantage Ingres buying price.
I don't have any information of the price in U.S.A and Europe.
Please let me know your buying price with H/W spec(Server Maker, Server
Model, OS, CPU number).

Anyone recall how to use one Ingres environment variable to define another?
E.g.
ingsetenv ENVIRO1 foo
Ingsetenv ENVIRO2 %ENVIRO1%\foo2

Want to create a temporary table in a stored procedure it is not
getting created and is returned by errors.
How to run a DDL commnand inside Stored Procedure?
create table .... ?? Is it possible through some other ways. The

I am running INGRES II on Solaris box. While running a Stored
procedure (which first select rows from a table n then inserts in the
same table with different period) getting message Transaction log
full.

G'day.  I had a situation yesterday where a runaway transaction was logging
a heap of stuff to the journal area.  To conserve space I bzipped most
of the journals (but not the most recent half-dozen) and then created
zero-length files to stand in for the journals that had been ...

Is it possible within Openroad (4.1) to determine the value of an
operating system environment variable?
i.e. I wish to find out the value of the Windows environment variable
%TEMP% and place this into an Openroad global variable.

Fabian Pascal - one of the original Relational Warriors - makes the
following statement in an article he wrote in 2002 (you'll find it in
http://searchdatabase.techtarget.com/tip/1,289483,sid13_gci788645,00.html
?FromTaxonomy=%2Fpr%2F284872):

I know that this type of information is probably buried in
documentation, but I would like an opinion based on 'experience', which
I'm sure there is quite a lot of that here.
I have a situation here where the database space has 'grown' to about 45

What can be the reason for long execution time of the query:
Query text:                                              
 modify session.g4i002 to TRUNCATED                      
Query Send Time:       Thu Apr 22 16:25:09 2004          

I have 2 error messages in errorlog file:
  E_OP0886_QSF_PALLOC
  E_QS0001_NOMEM
QSF dynamic memory pool is exhausted.

It was mentioned to me the other day that upping the pagesize on system
catalogues would/could increase performance. If this is true then how would
I go about changing the pagesize of the tables in IIDBDB? I know I can do
this in the production databases using "modify" - but on ...

All, is there a way to monitor the Input/Output for System Catalogue pages
in Ingres II 2.0/9808
Thanks Greg
Gregory Wilding

I have been asked to look at providing a failover solution (active -
passive) for an application which uses an Ingres database.
The Ingres database is checked every 60 seconds and if found not working
it's failed across to another system.

We have Ingres Version II 2.0/0308 (axm.vms/00) Patch 9771 on OpenVMS
V7.2-1H1
on a 3 cpu AlphaServer ES40.
Last weeks we encountered lots of crashes of our Ingres installation.