Hi Dudes,
I have two installations of II 2.6/0305 (axp.osf/00) with patch 10993
applied.
I have created a database on one and used the same script to create

e always had problems with NET on windows (memory leaks, etc) but it
appears that we are starting to get problems on server versions now. Our
unix versions don't have anywhere near so many errors. We use the standard
ODBC drivers freom CA. (This is new for us, we have only really ...

I find that a lot of time is wasted trying to understand why a database
procedure doesn't behave as expected (i.e. it doesn't return an error it
just doesn't do what I was hoping it would)
Is there any tool to allow stepping through the stored procedure line by

Hi Paul,
What ingres version and patch?
Actually the printqry looks pretty good. What do you think is the
problem there?

I'm trying to run an optimizedb against a table with  long varchars, and
after running for about 10 minutes,  it reports there are no rows in the
table.
The table has 34 million rows.

I've come across a strange problem where an exclusive table lock is
being taken on a large table which is uniquely keyed on a single column
when the table is updated by the key column.  The table key is hash
unique and the table has about a dozen rules.  The table is not scanned

I've have set the following on my PC to try and identify the ODBC
client sessions from IPM on the server:
ingsetenv ING_SET "set lockmode session where readlock=nolock; set
session with description='Steve McElhinney'"

Hi Dudes.
    I've been playing with a new problem and would like to see if
people could just shed some light on how widespread it is. I suspect
that this is generic to All Ingres.

I have an old 6.4 installation (6.4/06 (hp8.us5/00)).
When IPM is started we get de following error:
IPM: IPM: Attempt to connect to server failed.
Check permissions or installation.  Either the correct privileges are

We all know what the manual says about errors in database procedures:
"If the procedure was invoked by a rule, an error has the following effects:
- The procedure is terminated.
- Those statements in the procedure which have been executed are rolled

I'm trying to run a iizck on a VMS installation to fix a timezone
issue.
Looking at Document ID:  TEC265089 on supportconnect
1) Obtain a copy of the new timezone rules for the United Kingdom

We have some Simp. Chinese data in Ingrest 2.6 on a HP machine. We have
been storing dbl-byte data for years.. but not all front-end can
display them correctly. For example:
- it works for ISQL... so we have a system written in 4GL programs on

 I haven't posted to this newsgroup (or any) in about 10 years so be
kind.
 Today I decided I needed to do a median on a Ingres column after 20
years of using Ingres.  Looked at Roy's posting 10 years back about SQL

Is anyone prepared to part with a (script?) programme that
determines whether the installation is functioning properly?
Ideas so far:
Run SQL on some database to see if that works/is available.

   Okay this is seriously off topic, but I just gotta share this one.
   As a little background...
My brother in law noticed that his missus was getting broody.
Desparate to avoid the breeding issue he decided on a cunning plan,