[Info-ingres] Ingres/STAR, ING_SYSTEM_SET and set lockmode

Hi Dudes,

I'm connecting to a STAR server ifrom an installation which has an
ING_SYSTEM_SET specifying a:
set lockmode session where maxlocks=100;

The connection occasionally succeeds and occasionally fails. Once it
fails it keeps failing.

I get:
[ingres@dune ingres]$ sql a6::all2003_ddb/star
INGRES TERMINAL MONITOR Copyright 2003 Computer Associates
Intl, Inc.
E_US1722 While in a multi-query transaction, the only WHERE clause
parameter of SET LOCKMODE that can be specified is TIMEOUT.
(22-NOV-2005 13:23:33)

E_RQ0042 Preceding message is from LDB=iiall2003_ddb,
NODE=a6,
DBMS=INGRES
(22-NOV-2005 13:23:33)

E_QE0545 RQF detected the loss of an LDB association.
(22-NOV-2005 13:23:33)

Anyone got any ideas? I cant see why the STAR server would give a
monkeys about the lockmode statement, and why does it think its in a
transaction already? And why isnt this consistent?

Martin Bowes
--
Random Farscape Quote #27:
Rygel - I don't believe the Universe will follow my preconceptions, but I
know a fact when it hits me in the face.

.