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

10
votes
1answer
728 views

Why does NOT IN with a set containing NULL always return FALSE/NULL?

I had a query (for Postgres and Informix) with a NOT IN clause containing a subquery that in some cases returned NULL values, causing that clause (and the entire query) to fail to return anything. ...
8
votes
2answers
1k views

How to delete a procedure which name is ambigous?

I am using informix... I dont know how i did it, but there are two procedures with the same name in my database. When i try to remove them with a DROP PROCEDURE myProc; then i get a error message ...
4
votes
2answers
419 views

How should I best design the tables and relationships, given the following rules?

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 ...
4
votes
2answers
400 views

Does a cluster index provide more benefits than pre-sorting the load file and creating non-cluster index?

Informix 11.70.TC4DE: CREATE TABLE cluster_tbl ( fk_id INT, data CHAR(2048) ); LOAD FROM "presorted.ld" INSERT INTO cluster_tbl; CREATE UNIQUE CLUSTER INDEX cl_idx ON cluster_tbl(fk_id); ...
3
votes
3answers
3k views

What does NVL stand for?

What does NVL stand for? I'm talking about the Oracle and Informix (perhaps some others too) function used to filter out non NULL values from query results (similar to COALESCE in other databases).
2
votes
2answers
84 views

Filter Stored Procedure Result (Informix)

IBM Informix Dynamic Server Version 11.50.UC5XA. I have a Informix database. This database contain a stored procedure with name of 'sp_agent_details' that get two DateTime Parameter. This stored ...
2
votes
1answer
628 views

ODBC Connection As Clustered Resource

First step in a long process of creating a Linked Server to an Informix database on a Sql 2008 (Win 2003 x64) cluster. I was wondering how to go about creating an ODBC connection as a clustered ...
2
votes
1answer
165 views

Can't Select a View on Informix

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 ...
2
votes
3answers
5k views

What's a good (free) client for Informix on Windows? [closed]

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 ...
1
vote
3answers
264 views

Why can't I create a database in a 107GB dbspace I created for my instance?

11.70.FC6 Developer Edition on Windows 7 Pro 64-bit: Downloaded via IIUG link and installed it. I created a custom DSS instance named "server" with a 128GB dbspace named "datadbs". Install wizard ...
1
vote
2answers
385 views

serial field issue

Q: I use a serial as a datatype for my primary keys in my tables. I insert a lot of data then truncate these data one after one many times to test the data entry. My question is: Is there any ...
1
vote
1answer
2k views

What joins are available in Informix 9.2?

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 ...
1
vote
1answer
18 views

How to know what index is set on the table with command line in informix?

I'm using the Informix DB. I want to detect what index the table has using command line. I used dbschema -d dbName -t tableName | grep index to detect the index. What's my problem is that the ...
1
vote
1answer
139 views

OVERLAPS for Informix

Does Informix have a function equivalent to OVERLAPS, which finds out whether or not two time intervals have any time in common?
0
votes
1answer
16 views

Moving the IBM Informix IFMXDATA directory to another machine

I'm a total newbie when it comes to Informix DBs, and I'm stuck with what looks like files that contain an Informix database. I'd like to know if it's possible to add or import these files into an ...
0
votes
0answers
4 views

Is there a generic (perl DBI based) command line tool to run SQL queries?

I am looking for a command line tool to run SQL queries against an Informix database. Considering the ubiquity of perl DBI modules, I was wondering if there is maybe a tool out there that is already ...
0
votes
0answers
94 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 ...
0
votes
1answer
187 views

connection to Informix still active despite closing?

I have a small C# utility connecting (via the IBM Data Server Provider for .NET) to a Informix DBS (version 11.7) and sending one or two queries to several databases. Even though I close each ...