Is it possible to create an insert or update trigger that checks the value
of a particular field to be stored, looks up in a table on another database
to check that that value does not exist there, and returns an error and
prevents the update/insert if it does?

Hallo Keith,
Thanks again. (hope you had a nice holiday).
Another question (for all):
When I do  "cdr stop group groupname"

Folk, I am working on adding some features to myschema and I'm running out of
sensible single letter mnemonics.  I figure I have two alternatives:  Use a
master flag with options ala the -g flag in onstat or go all the wasy to
GNU/POSIX style long options.  The first solution is ...

7.31 UD8 on SCO Unixware 7.1.1
Our customer has just upgraded from UC6 -> UD8, and is seeing these shared
memory segment messages at start-up time.  We've not seen them before on UD8
on other OSs (AIX or Linux).

Hi,
 Sorry I am not an informix dba, and I was faced to copy a
sub-database(sorry I don't know the clear name of such concept, as
informix is like sql-server, which used multiple database) from one

When I try to start the informix dinymix server 7.31, it doesn't work.
The only message showed by XP is that  Informix Dynamix Server Message
Service
was started and stoped .

I've two table (t1 and t2) in the informix database with serial fields in.
There is a unique index on the serial fields.
First process inserts records in t1. The serial field is filled with the
value 0.

Hello all,
We have an existing INFORMIX 4GL application connected to INFORMIX SE
7.2 UC4 database. The connectivity is based on seipcpip protocol.
We now want to enable SESOCTCP protocol and create the database under

we are experiencing a very silly behaviour with the following
scenario:
- 120 processes (java/jdbc) creating a cursor on a specific table (no
join,

Red Hat Linux Enterprise version 3. Kernel: 2.4.21-4.EL
I am trying to install Informix 9.4 using Unix bundle installer. The
installation failed with the following messages:
Installing IBM Informix Dynamic Server 9.40

Hi, everybody,
I've just run into a very unpleasant problem obviously related to SPL
caching on HDR secondary.
Steps to reproduce: (ANSI database, IDS 9.40uc5, also reproduces

is this possible to build a cluster with 2 informix (IDS 9.x) DB (load
balancing,high availability..)?
what must i look at ?

I am trying to install Informix IDS 9.40 on Red Hat Linux Enterprise
version 3. Kernel: 2.4.21-4.EL
I am using IBM Unix bundle Installer. Installation failed for every
product (ISA, IDS...) with messages like:

The Register has an article by Philip Howarth of Bloor Research which
fairly clearly describes IBM's problem with Informix marketing:
http://www.theregister.co.uk/2004/10/19/ibm_informix_db2/
«IBM has a problem with Informix. It is one of those problems that is

How can I get different Match Patterns in data stored in
BLOB(Text)Variable in INFORMIX Database ?
For Example :
Suppose in my Database named "Employee" in INFORMIX ,there is a BLOB