At work, we have an Informix database server, managing our data. We have multiple queries spanning 70 lines and accessing 10+ tables using a join.
The query takes approximately 4s to return. All the ...

We have a huge query on an Informix database that is not performing well. The query is doing a join of 9 different tables. Maximum row count is just 40,000 rows. The query also has 9 sub-queries, and ...

What are possible causes for the following error?
DB Error: connect failed [nativecode=08004 [unixODBC][Informix]
[Informix ODBC Driver [Informix]Server rejected the connection.]
I have doubled the ...

There is an existing database that was created in Informix. I would like to export it and then import it into MySQL.
I tried to export it using dbschema and it created the dbase.sql file and several ...

I have a table which for the same key, it will always have one record with value 'P' but sometimes that same key could have two records one with value 'P' and one with value 'L'; I need to create a ...

I require to query an informix database using parameters and Excel. When the query is executed in Microsoft Query the dataset is fetched and returned succesfully, when I attempt to return to Excel the ...

I'm using Informix IDS 11.50 Innovator-C edition running on Slackware Linux 12.0. I've been running a very small Database on it(less than 10000 records on the biggest table).
I'm trying to select a ...

In a Pawnshop business, customers pawn, sell or buy items. A contract which specifies the customers information, the items, and the terms and conditions is created whenever customers pawn, sell or buy ...

I'm testing some queries with an old version of Informix (9.2.1) and can't seem to execute even the most basic queries containing RIGHT OUTER JOIN or FULL OUTER JOIN. Tried several variations (RIGHT ...

I'm looking for a GUI client for Informix on Windows (mainly to view data and execute queries), free would obviously be nice but I know Informix is used mostly in corporate environments and free may ...