Stack Overflow
Stack Overflow

Questions tagged [informix]

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.

From the marketing blurb:

The powerful new generation of technology revolving around the proliferation of connected devices known as the "Internet of Things“ is transforming the way we live and do business. Harnessing data from billions of devices depends on the ability to store, access and query all data together, seamlessly, for speed-of-thought insight and local decision making. IBM® Informix® is forging new frontiers with its embeddability and unique ability to seamlessly integrate SQL, NoSQL/JSON, timeseries and spatial data, with a rich set of APIs, including REST, that enhance development simplicity, flexibility and time to market.

http://www-01.ibm.com/software/data/informix/

This tag is appropriate for questions about IBM's products in the Informix family - or any predecessors to those products. Such products include:

  • IBM Informix,
    To know the actual editions read this IBM technote: Comparing Informix Editions
  • Informix Dynamic Server (IDS) (2004-2010) — an older name for what is now just Informix,
    • Enterprise Edition
    • Workgroup Edition
    • Express Edition
  • Standard Engine (SE),
  • Extended Parallel Server (XPS),
  • OnLine,
  • ESQL/C,
  • Informix Genero
  • I4GL,
  • ISQL.

It also includes questions about the Informix implementations of generic interfaces to the Informix databases, such as ODBC, JDBC, .NET, OLE/DB, ADO, etc.

This list is not exhaustive; there are other esoteric products which it would be legitimate to tag with 'informix'.

2213 questions
193
votes
27 answers

Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints

I make an outer join and executed successfully in the informix database but I get the following exception in my code: DataTable dt = TeachingLoadDAL.GetCoursesWithEvalState(i, bat); Failed to enable constraints. One or more rows contain values …
Anyname Donotcare
  • 11,113
  • 66
  • 219
  • 392
26
votes
4 answers

Informix SQL - List all fields & tables

Informix iSQL has a command "info tables;" that shows all tables. The syntax for viewing the fields and their respective data types is "info columns for table;" Is there a similar command that shows table.field for all tables and all fields?
CheeseConQueso
  • 5,831
  • 29
  • 93
  • 126
20
votes
3 answers

How to get multiple columns in a single SQL CASE statement?

I'm trying to get multiple columns(insuredcode, insuredname in this case) from a single CASE statement. The following query has been tried but it concatenates both insuredcode and insuredname as one column. What is the correct syntax to return…
Michael.Y
  • 335
  • 1
  • 2
  • 7
18
votes
3 answers

How to find informix datasource in visual studio to connect to

I want to use EF6 with Informix database . I have searched a lot and find that i can get EntityFramework.IBM.DB2 6.0.2 from NuGet for Both Informix and DB2 but my main problem is the connection How to create a connection to my informix database i…
Anyname Donotcare
  • 11,113
  • 66
  • 219
  • 392
16
votes
9 answers

testing inequality with columns that can be null

So, I asked a question this morning, which I did not phrase correctly, so I got a lot of responses as to why NULL compared to anything will give NULL/FALSE. My actual question was, what is the time honored fashion in which db guys test inequalities…
rouble
  • 16,364
  • 16
  • 107
  • 102
14
votes
4 answers

How can I use ActiveRecord on a database that has a column named 'valid'? (DangerousAttributeError)

I am accessing a database that I can't change and it has a column named valid defined. Anytime I try to access an attribute, I get this exception: valid? is defined by ActiveRecord (ActiveRecord::DangerousAttributeError) The exception makes…
Michael
  • 1,919
  • 2
  • 16
  • 26
13
votes
6 answers

Need to perform ORDER by Twice

I want to sort according to date first and then if date is similar then according to id..How to do that in Informix/HSQL query?
coderslay
  • 13,960
  • 31
  • 73
  • 121
12
votes
2 answers

Rewrite left outer join involving multiple tables from Informix to Oracle

How do I write an Oracle query which is equivalent to the following Informix query? select tab1.a,tab2.b,tab3.c,tab4.d from table1 tab1, table2 tab2 OUTER (table3 tab3,table4 tab4,table5 tab5) where tab3.xya = tab4.xya AND tab4.ss =…
divya chekuri
  • 337
  • 5
  • 6
  • 10
12
votes
7 answers

Converting a String to HEX in SQL

I'm looking for a way to transform a genuine string into it's hexadecimal value in SQL. I'm looking something that is Informix-friendly but I would obviously prefer something database-neutral Here is the select I am using now: SELECT…
Claude Houle
  • 41,064
  • 8
  • 33
  • 42
11
votes
1 answer

Query full Informix database version using sql query

What is the query required to get the full database version in an Informix database?
h-rai
  • 3,636
  • 6
  • 52
  • 76
11
votes
5 answers

update Informix table with joins

Is this the correct syntax for an Informix update? update table1 set table1.code = 100 from table1 a, table2 b, table3 c where a.key = c.key a.no = b.no a.key = c.key a.code = 10 b.tor = 'THE' a.group = 4183 a.no in ('1111','1331','1345') I get the…
user867621
  • 1,147
  • 4
  • 16
  • 34
10
votes
1 answer

How to launch Informix via testcontainers?

I'm very interested in using testcontainers in my project. However, I'm having a hard time setting it up to work with Informix. Note that I can start an informix container using Docker-for-Mac and it will build and start. Not sure it can work…
slashdottir
  • 7,835
  • 7
  • 55
  • 71
10
votes
5 answers

life span of temp table

I have the following procedure: CREATE PROCEDURE foo () SELECT * FROM fooBar INTO TEMP tempTable; -- do something with tempTable here DROP TABLE tempTable; END PROCEDURE; What happens if there is an exception before the DROP TABLE is…
rouble
  • 16,364
  • 16
  • 107
  • 102
10
votes
5 answers

How to do an insert with multiple rows in Informix SQL?

I want to insert multiple rows with a single insert statement. The following code inserts one row, and works fine: create temp table mytmptable (external_id char(10), int_id integer, cost_amount decimal(10,2) ) with no log; insert into mytmptable…
Highly Irregular
  • 38,000
  • 12
  • 52
  • 70
9
votes
7 answers

Show a one to many relationship as 2 columns - 1 unique row (ID & comma separated list)

I need something similar to these 2 SO questions, but using Informix SQL syntax. Concatenate several fields into one with SQL SQL Help: Select statement Concatenate a One to Many relationship My data coming in looks like this: id …
CheeseConQueso
  • 5,831
  • 29
  • 93
  • 126
1
2 3
…
99 100