Informix is an SQL-based object-relational, OLTP/OLAP, NoSQL DBMS produced by IBM. This tag is appropriate for questions about any of the products with Informix in the product name.

learn more… | top users | synonyms

0
votes
2answers
238 views

Creating a MySQL db from an Informix database

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 ...
0
votes
1answer
66 views

Optimizing an Informix query — Specify architectural solutions if possible too (like caching service)

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 ...
0
votes
1answer
31 views

Informix Server Rejected Connection

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 ...
0
votes
1answer
31 views

Informix: is it necessary to update statistics on views?

In informix i have a partitionated table for performance reasons. One contain the latest data and another the historical data. Also, there is a view which contains data from both. When i update ...
0
votes
0answers
13 views

Retrieve one of two possible values from 1 table in INFORMIX

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 ...
0
votes
0answers
428 views

Multiple table rows in one row Informix

I have problem just like this one but in Informix. I have table with 2 attributes ID, email like this one: ID email 1 my_mail1@mail.com 2 my_mail2@mail.com 2 my_mail3@mail.com 2 ...
0
votes
0answers
162 views

Passing parameters through Excel to an Informix DB works through MS Query but fails when returned to Excel due to General Error

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 ...