Informix is an SQL-based object-relational DBMS produced by IBM. This tag is appropriate for questions about any of the products with Informix in the product name.
0
votes
1answer
21 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 ...
1
vote
3answers
113 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 ...
0
votes
0answers
52 views
Informix Benchmark select
I'm not very familiar with databases and need your help. We have following case. Informix DB is running and target table contains 1.5 million records. We want to run application which periodically ...
3
votes
2answers
301 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 ...
0
votes
1answer
109 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 ...
4
votes
2answers
264 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);
...
1
vote
1answer
1k 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 ...
9
votes
1answer
383 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.
...
2
votes
2answers
1k 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).
1
vote
1answer
111 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?
2
votes
1answer
444 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 ...
8
votes
2answers
748 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
...
1
vote
2answers
250 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 ...
2
votes
3answers
3k 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 ...
