Top "Informix" questions

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 concatenation one-to-many informix group-concat

Why can't I use first in informix subqueries

Why can't I use select first in subquery? Here I have some pseudo select which throws exception: Cannot use 'first', …

sql informix

ignore insert of rows that violate duplicate key index

I perform an insert as follows: INSERT INTO foo (a,b,c) SELECT x,y,z FROM fubar WHERE ... However, …

sql database insert indexing informix

What is the easiest way to copy a database from one Informix IDS 11 Server to another

The source database is quite large. The target database doesn't grow automatically. They are on different machines. I'm coming from …

migration rdbms informix administration

Is there a built-in function to test for alpha or numeric data in Informix 7.3?

I have been searching around for a SQL function that tests a value for being alpha or for being numeric. …

sql function informix built-in isnumeric