Popular "informix" questions

I make an outer join and executed successfully in the informix database but I get the following exception in my …

c# asp.net sql database informix

How do I write an Oracle query which is equivalent to the following Informix query? select tab1.a,tab2.b,…

sql oracle left-join informix outer-join

I'm looking for a way to transform a genuine string into it's hexadecimal value in SQL. I'm looking something that …

sql informix hex

I am trying to convert an Informix query to Oracle: The Informix query looks like this: SELECT r.aa, n.…

sql join oracle11g informix

Informix iSQL has a command "info tables;" that shows all tables. The syntax for viewing the fields and their respective …

sql field informix isql

I'm trying to get multiple columns(insuredcode, insuredname in this case) from a single CASE statement. The following query has …

sql case informix

I have problem while converting varchar type to Int type in Informix. Actually I don't know if the value is …

informix casting

I have 2 fields I'm working with that are stored as smallint military structured times. Edit I'm running on IBM Informix …

sql datetime formatting informix

What is the best way to use a only the date part of a datetime field in a query? I …

sql date datetime informix

I need to Convert a string say '12/12/2013 14:30:56.583' to be converted in Date Format like 2013-12-12 14:30:56.583 in Informix …

sql informix

Top "Informix" questions