Tag Info

New answers tagged

0

There is an answer on Stack Overflow to the question Show a one to many relationship as 2 columns — 1 unique row (ID & comma separated list) which demonstrates how to create a user-defined aggregate in Informix that functions more or less like the GROUP_CONCAT aggregate in MySQL. You can then easily use this to solve the problem in this question: ...


1

This answer assumes that your table Ex1 has columns: key_col — the key column. flag_col — the flag column, containing L or P (with a check constraint). data_col — a proxy for the unidentified set of columns containing the other data. Primary key on key_col and flag_col. A view like this should work (I didn't say it would work fast): CREATE VIEW ...


0

When I use an Informix command finderr, I get the output shown: $ finderr -23101 -23101 Unable to load locale categories. An invalid locale name was supplied for the locale initialization. The environment variable specifying the locale category has a wrong value. Check the value of the corresponding environment variable, CLIENT_LOCALE or DB_LOCALE. If ...



Top 50 recent answers are included