hi all!!
last question of this year....
I want to use a trigger. Purpose is to keep track of changes in a table.
create trigger TRIG1

I have a need to restore our production DB (9.4) to a junk box to
salvage a table that recently lost some data.  I am not very familiar
with the steps required.  The production server is running Solaris 9
with raw devices.  I was hoping to restore to a Red Hat box using

When I use
dbschema -d database -f all
I get an output containing 2011 stored procedures.
A count(*) of sysprocedures yields 2350.

How to assgin the value to Dynamic Variable Names in SPL? Something
like:
DEFINE l_var1    VARCHAR(255);
DEFINE l_var2    VARCHAR(5);

Hi guys, I got trouble installing Informix 7.3 on a RHEL box.
"bash: /home/informix/installserver: /usr/lib/libc.so.1: bad ELF
interpreter: No such file or directory"
This error message keep popping out every time when I try to run the

In my stored procedure, there is a sql:
select first 1 sales_emp_key, end_customer into t_sales_emp_key,
t_end_customer
from delivery_fact

Good evening all,
I am a new (6 months) DBA for Informix.  I am looking to get training
on Database Administration.  I would like to get training sooner than
February 2007 (Advanced DataTools & IBM offer training in February).

Next question.
How long has RMAN been around and trustworthy?
I can't quote how long onbar has been around (somebody out here probably
knows), but I know we trusted onbar much sooner than our oracle dba

When you have cascading triggers, are they synchronis or asynchonis in
nature.
Scenario:
You have end user (Fred)

So I've been doing Oracle for almost 20 years now and I've been
assigned to learn Informix IDS so I can become a backup Informix DBA. I
thought when IBM acquired Informix they would kill it and move
everybody to UDB (DB2 for non-mainframe). So what is happenning to the

how to determine in SPL/SQL time zone the client has or the server is
into?
It doesn't matter to me which one, as they are both the same.
I just don't want to create another spl routine just to determine this

"Please accept with no obligation, implied or implicit, my best wishes for an environmentally conscious, socially responsible, low-stress, non-addictive, gender-neutral celebration of the winter solstice holiday, practiced within the most enjoyable traditions of the religious ...

From the Independent Oracle Users Group
http://www.oninit.com/article/newstracker.php?id=21
At last they are starting to realise :)
Made me smile

Does anyone know if the shadow replicates created during a cdr sync repl
will be automatically deleted or will I have to manually remove them?  If
they are removed automatically, when are they removed?  I still see them
hanging around on the target servers that were sync'd.

IDS: 9.4 FC3
O/S: HPUX 11.11
We have a .NET app that uses log4net to write application exceptions to
our database to help debugging.  However when it inserts the .NET