Top "Informix" questions

SQL character field concatenation (without using CONCAT() or +)

I'm trying to concatenate 3 [char(32)] fields:title1title2title3 into one field, but the catch is that I'm using an …

sql string informix concatenation concat

How do I get constraint details from the name in Informix?

When programming a large transaction (lots of inserts, deletes, updates) and thereby violating a constraint in Informix (v10, but should …

database constraints informix

Date time functions help informix

How can I use the date add or date diff functions I have a scenario where I need find people …

sql date informix

Inserting datetime values into an informix table fails

I am trying to insert a test value '10.06.2011 10:24' into an informix 7.3(sadly) database. The destination column is System.…

sql datetime informix

Row numbers for a query in informix

I am using informix database, I want a query which you could also generate a row number along with the …

database informix row-number

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 …

sql informix hsqldb

How do I list all stored procedures in Informix?

I'm looking for a way to list all the stored procedures in my database running on Informix. Is there a …

sql database stored-procedures informix

How to enter new line using sql command INSERT

Q: I wanna to know the syntax of SQL query of inserting new line in my table. I mean ,I …

sql newline informix dml

Find Informix table and column details using SQL query

I want to get Informix database table information and column information such as table names column names of the table …

sql informix

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 …

sql informix