we have a trigger on an update_date field - pretty simple:
create trigger "informix".t_upd_comment update of
id,from_class_id,from_id,type_cid,status_cid,seq_num,comment,update_version,created_by,create_date,updated_by
on "informix".comment referencing new as new    for each row

Greetings from the IIUG 2009 Conference!  We are all having a great time,
learning from each other, speaking to the IBM developers and management, and
networking among ourselves.  We've missed the opportunity to be with
everyone who could not make it this year.  Hopefully the ...

Running IDS10.0.uc5 on aix5.3.
We have a table that has some bad queries written against it that are having poor performance now. It is also a pretty wide table, lots of varchars.
We aren't going to re-write the queries at this minute, but instead I am going to fragment the table.

I have a complex UDR that uses RETURN x, y WITH RESUME to
generate a list of values.
I have found that with IDS 11, I can do
SELECT * from TABLE(my_function(param));

Has anybody any experience with/opinions on Genero DB
(http://www.4js.com/templates/en/6/affiche.php?idparent=3_1&id=51).
Backed by one of Informix's biggest TPVs, 4Js, it seems a straight
competitor to low-end Informix.

A client just sent me this question...not really my area, so any help
would be greatly appreciated!
"Can you tell me if there is a tool that will create web-based reports
from an Informix Database? I also wonder if there is a tool that has a

Good Morning:
I would like to audit some tables in my database and after reading the "Informix Trusted Facility Guide" I understand that I can't choose the tables I want to audit. The only way I have founded to do this is auditing the access to all the tables.
Is this correct? Is ...

I noticed that I could down load it for my platform, although it says
the release date is 4/28/09. Is this the final version and they are
less behind than they thought. Also, what are the 11.50FC4WE versions
What does the "WE" mean?

a few queries for all -
1.  Is version 3.5 final yet?  This page has the driver listed as
"trial": http://www14.software.ibm.com/webapp/download/search.jsp?go=y&rs=ifxjdbc
2.  What is the recommended JDBC Driver version to use with IDS 10?  I

do we have something like ->>>
select substr(audit_note, 1,3) from table;
i got "Blobs are not allowed in this expression"
anyone pls helps

Hello, all,
We are about to migrate from 9.20HC1 on HP-UX11 to 11.50UC3 on RHEL
and was wondering if anyone knows off the top their head a few things:
Is the migration path of 9.20 to 9.21 and then to 11.50 an absolute

http://www.nytimes.com/2009/04/21/technology/companies/21sun.html?_r=1&ref=business
This could be bloody .... :o>

Ok, from an article on El Reg:
"By comparison, Software Group had a pretty decent quarter and
contributed mightily to Big Blue's bottom line. Even as revenues for
Software Group fell by 6 per cent (up 2 per cent at constant currency)

We have some IDS 9.40.FC4 instances on AIX 5.3 runing quite beautifully. In
one of them, I'm not able to run dbschema and get the following message :
testx3devx:~> dbschema -d db_olf -t ag
Unknown error message 19000. testx3devx:

Good day!
I'm presently working a Debian Linux 5.0 development server with IDS
11.5 Developer Edition. My instance and database have successfully
been created and now I'm trying to connect to the Db using SQuirreL