Afternoon all
IDS 9.30HC5, HP-UX 11i, Data Protector 5.1
We're getting errors on a backup of a test system lately, nothing's
changed at all recently but the weekly backup is failing with code

I'm having trouble getting two columns to sum properly because they do
not have the same number of rows returned by the select.  I'm using
Informix SE 7.25.UC6R1.
select sum(tab1.cost), sum(tab2.cost)

In preperation for migration from IDS 9.40 to 11.5 we have to complete all
in-place alters. We have tables up to a billion rows with many pending
in-place alters. The amount of data adds up to some TB.
The database servers are in 7x24 production. Now I'm looking for the best

Hi all Informix experts,
i would like to put the Informix DB v9.x on SAN and take snapshots daily so that in case there is data corruption, I can rollback to previous version. However, I found Informix is a bit different from Oracle and Sybase as they have backup modes but ...

Using the .NET provider for Informix, I need to conditionally create a
database. So far, I connect to the 'sysmaster' database, to perform a
'SELECT name FROM sysdatabases WHERE name='databasename' query, which
tells me if the desired database already exists. But then, if the

Watch history in the making as Sun Micro is taking a hit after the
MySQL purchase.
Can you say $1 billion dollar waste?

Hi, i note there is not a FGL_SETENV function in traditional Informix
4GL
Anybody has resolved how to set an environment variable (linux, bash)
from 4gl program??

Just one more anecdote to share around.
A major, nameless, Informix site with over 50 servers online, who was talked
into converting all of their servers into Oracle in the past year, is having
major performance problems with several of the handful of already ported

Between
6 a.m. and 7 a.m. on the ultumos 4 days, the archivo.log records the
same type of event, doing some chunks that are put down mode.
06:36:47  Rollforward of log record failed. iserrno = 101

Can anyone tell me about this IC number (IC58999) as the link from the
RSS feed and from the support search site on IBM is broken (says Page
Not Found).
I can ring tech support and raise a PMR to get them to send me the

I have an install of 11.5 in production and one in development.  The
installs should be the same, except one machine is fedora and the
other is debian.  On one box I my query works on the other I get a
-360 error "Cannot modify table or view used in subquery." I am

Hi !!
Our DBA tell us (developers) that in informix IDS 11.5 and his new
version of Informix 4GL we can query web services from Informix 4gl
program.

Hi,
 I have here a IDS 11.50 UC2 Developer with BTS 1.10 installed and registered in a database.
Now I will migrate all data to another instalation with IDS 11.50
UC3 Developer on another machine, and I want to use the dbexport. So I

I'm been using the SQL Developer GUI from:
http://sqldeveloper.solyp.com/
I'm using this to run queries on a Informix 10 db and also draw
diagrams of the table relationships.

Whoops! I forgot to post this!
http://obotheclown.blogspot.com/2008/11/informix-roundup-19-nov-2008.html