Top "Informix" questions

Informix: Select null problem

Using Informix, I've created a tempory table which I am trying to populate from a select statement. After this, I …

sql select informix

How to do an insert with multiple rows in Informix SQL?

I want to insert multiple rows with a single insert statement. The following code inserts one row, and works fine: …

sql informix

Substring in Informix

I need to split a field(Name) into Two (First Name and Last Name) based on a comma in Informix. …

substring informix

Dispose the connection or Close the connection

Which one of the following two methods has better performance ? using( var DB_Connection_s = new DBConnection() ) { //todo: interact with …

c# asp.net performance database-connection informix

Informix SQL 11.5 storing query results in a file with a dynamic name

I am trying to store the results of a query in a file. The following command accomplishes this task: UNLOAD …

sql informix

life span of temp table

I have the following procedure: CREATE PROCEDURE foo () SELECT * FROM fooBar INTO TEMP tempTable; -- do something with tempTable here …

sql database informix temp-tables

SQL substituting NULL using NVL, having problems checking substituted value in the where clause correctly

I am running a query to display messages when the from date is before (<=) the current date and to_…

sql informix nvl

Extract TIME from DATETIME - informix

I have lost few hours looking for one row solution and didn't manage to find it. I have some value (2013/01/03 07:13:26.000) …

sql timestamp informix etl

How to see queries executing on Informix DB

I would like to know if there is a way to see queries executing on Informix. If I use onstat …

sql select command informix

Connecting to Informix using .NET

Server Information Sun Microsystems Inc. SunOS 5.8 Generic Patch October 2001 Server: Informix Dynamic Server Version 7.31.UD3 Information: Link: Connecting to Informix …

c# .net visual-studio-2010 database-connection informix