Questions about informix
Read more about informix
python (65.1k questions)
javascript (44.2k questions)
reactjs (22.7k questions)
java (20.8k questions)
c# (17.4k questions)
html (16.3k questions)
r (13.7k questions)
android (12.9k questions)
Informix doubly nested MULTISET remains empty
Given this schema:
create table a (id int);
create table b (id int, a_id int, c_id int);
create table c (id int);
insert into a values (1);
insert into a values (2);
insert into b values (1, 1, 1);
i...
Lukas Eder
Votes: 0
Answers: 1
Internal error when lateral unnesting collection derived table in Informix
I'm playing around with what's possible in Informix related to collection derived tables and nested collections. Given this schema:
create table t (i int);
create table u (i int, j int);
insert into ...
Lukas Eder
Votes: 0
Answers: 1
How to nest MULTISET in unnamed ROW in Informix?
Given this schema:
create table t (i int);
create table u (i int, j int);
insert into t values (1);
insert into t values (2);
insert into u values (1, 10);
insert into u values (2, 20);
The followin...
Lukas Eder
Votes: 0
Answers: 2
Informix and C: How to get the last inserted serial number from bigserial field type
We have a DB with multiple tables having "serial" type column. The legacy C application writes the data to these tables and uses "sqlerrd[2]" fetch the serial number of the data ju...
Liju Mathew
Votes: 0
Answers: 1