Hi All,
I found a temp solution of writing a dummy function or a procedure that
will return the value and when we need to change the value we just alter
the function\procedure. Don't know how effective it would be against a
select from a memory resident table. In Oracle and SQL server all
functions are compiled and kept in memory but I don't know how Informix
treats functions.

This is the only workaround I could find. If you ppl have anything else
that would help please share the same with me.

Regards,
Aash

-----Original Message-----
From: Aashish Ramsinghani - ASDC, Chennai
Sent: Monday, December 12, 2005 5:09 PM
To: informix-list@iiug.org
Subject: Need to create my own environment variable in Informix
Importance: High

Hi,
I am using Informix 7.2 on a AIX box and I have a peculiar need, in my
project we are working on a installing triggers for all the clients, but
a part of these triggers need to be inactive for some clients and active
for others. The trigger gives additional functionality that many clients
do not require.

I cannot use global variables as they are session dependent and
I cannot use tables because it will slow down the server with thousands
of transactions hitting the trigger. I also thought about using memory
resident table for this purpose but it is again very slow cause its a
transactional system and the client doesn't want any degradation in
performance.

Is there any way of creating a TRUE global variable that
initializes with the database and retains its status throughout all
sessions. like environmental variables. or is there any other way you
ppl would recommend.

Thanks again for all the help.

Regards,
Aash
sending to informix-list