I am currently running Informix 10 on a solaris box and someone here
has done / created something that started filling up the root dbspace.
I am the one who now needs to go investigate this and I am leaning
toward the idea that someone has created a table or index incorrectly

I have a table with row 1, row 2, row 3, and etc.
If I use foreach cursor to loop through the rows, will the rows been
retrieved in sequence, i.e. follow row 1, row 2, row 3, and etc
sequence? Or it will been retrieved without follow the original

Is there a time-limited version of IDS 10 available anywehere on the IBM
site or elsewhere?
I can find one for v11 (The "Developers' Edition"), but not IDS 10, which I
need.

It's very probable that I'm missing something, but I can't find files
cdotnet.sql and coledbp.sql. I have SDK-Client installed but those files
 aren't copied to INFORMIXDIR/etc directory.

I just got a third encounter of the lock's kind - I think.
I'm not at work for the next week, but there is this tiny voice in my
head asking for an answer.
We're running IDS 10.00.FC8 on Solaris Sparc. One of our applications

I'm looking for any ideas here as we seem to be getting the usual
round-around from both Informix and Sun...
We have an multi-database installation of IDS 10.0.UC4 on Solaris 9 (Sun
fire v480) which we are replacing with a reloaded engine IDS 11.10.FC2

I want to demonstrate the potential effects of update statistics in a
repeatable way but am having trouble doing so. This is for a customer
using an elderly version of Informix SE.
Here's what I did.

Hello everyone, i have recently a problem when my aplication start to
get a lot of locks, after that any other session try to make a select
or any other operation it return error 211 isam 101
Maybe i understand the error 211 but i dont understand why is

I´m searching for a possibility to convert  a char-field to a numeric one in a query.
I want to use the avg-function, but that only  allows numeric datatypes.
Thanks for your help.
Stephan

IDS 9.40FC9W2, Solaris 9, Backup with onbar and Legato Networker (nsrdbmi).
Following the manual it should be possible to retrieve Logical Logs file
from backup medium by specifying the Log ID.
The manual "Administrator Reference" says:

We are currently running our Credit Card Authorization host in a Intel
based Dell 6600 platform, SCO Unix 5.0.6 with Informix 7.3x. We have
been advised by the vendor to upgrade to Linux , Informix 10.x, Intel
platform (32bit). Could you please share your thoughts on the best

I'm trying to decrease 30 minutes from datetime recieved vy paramter,
but I need to correct syntax because none of the following working:
select (2008-04-14 10:00) - 30 units minute or
select "2008-04-14 10:00" - 30 units minute or

I'm creating index on "PPOIX" table. But it is taking too much time.
What might be the reasons
Pls help me ASAP

i have to date fields in informix
anyone knows how to get the variance in mins or second pls?
select (Act_DT - Appt_DT)  from contract
will return somelike like 0 01:21  -- h mm:ss