Can somebody please help translate this query ( for SQL Server ) for
use with Informix
SELECT DISTINCT
                     dbo.typeclass.name AS TypeClass,

I am learning Informix, my PM asked me the following question, Please
help me on this :
You are a new employee at the company and the only Informix DBA.
You were just informed by the management that one of the Informix DB

An update trigger was created on a few fields of a table.
The trigger is activated even if another field is updated.
Is this a bug in 7.31.FC6?
Thanks

FOR IMMEDIATE RELEASE
(AP) Armnonk, NY -- In what appears to be a complete reversal of fortune
for the beleagured database division of IBM known as Informix, IBM today
announced that they will indeed start marketing the entire product line of

<Cross posted to CDI & IDS Forum>
OK, an oddity for you.  I'm doing some performance and tuning testing using
multiple copies of dbload.
I'll tell you what I'm dealing with.  Anyone with any idea as to why the

We have SCO Unix 5.0.6
And Informix 7
We would like to do a level 0 backup to the hard disk instead of tapes.
But we have this 2GB file size limit on SCO 5.0.6

Want your vote on this:
http://www.informix-zone.com/node/569
Thank you.

I started getting this error from dostats when I started using IDS
11.5.FC1. I have the same exact databases
in IDS 10, IDS 9 and IDS 7 instances and do not get the error in any
of them.

IDS 11.10.FC2 on SUSE 10.1. Migrating development instance to another server
and storage array (same OS, version and onconfig). 130GB uncompressed ontape
backup made on old system will not restore on the new machine. Standard
output stops after listing the dbspaces. Message log ...

Dear Expert,
I need your expertise help, i got error as i put below.
What i need to know is, how to calculate SHMADD? seems the problem is
because i put wrong number for SHMADD and SHMVIRTSIZE

Call me a nut. I don't care.
I support all of the major databases except SQLServer, but I might
start learning it for the hell of it.
Informix wasn't my first database. Prior to Informix I dealt a bit

For functionality purpose, i am splitting a table into two.
eg: for table1, i am splitting it as table1_v1 and table2_v2.
i have taken the count of table1 and i am splitting the rows as
count(1)/2.

Yes, I subscribe and no, I don't mind getting it.
But if you look at it, the IIUG is doing more marketing on IDS's
behalf than all of IBM.
Its one thing to be a community advocate, its another to be the