Lab Sql

I am running into an strange issue using Informix (specifically, I am using the IBM.Data.Informix n… Read more Informix Memory Leak

I need to create function in Informix that calculates number of working days in between two given d… Read more How To Get Number Of Working Days In Informix Between Two Dates

I'm trying to write a script in C shell for selecting data from Informix database 8 working day… Read more Calculate 8 Working Days In Past In Informix

I have this Informix SQL statement which takes ages to run. Does anybody see any way to optimize i… Read more Sql Statement Performance Issue On Informix

I'm using an Informix (Version 7.32) DB. On one operation I create a temp table with the ID of… Read more Insert Into Temp Values (select.... Order By Id)

In one sentence: Statement.getGeneratedKeys() is occasionally returning an empty ResultSet, and I&#… Read more Getgeneratedkeys Returns An Empty Resultset

All SQL-based RDBMS' (versions up to 10 years old): Does the order of tables in a straight join… Read more Does The Order Of Tables In Straight Joins, With No Hint Directives, Affect Performance?

Am looking for a single query that can convert the following information in the table name:time … Read more Analytical Query

I'm looking for a way to list all the stored procedures in my database running on Informix. I… Read more How Do I List All Stored Procedures In Informix?

ISQL-SE 4.10.DD6 (DOS 6.22): My app has the following SQL script (CODE REVIEW) which my users exec … Read more Se: 'bcheck -y' Anomaly

I have the following dilema: My clients (mom-n-pop pawnshops) have been using my mgmt. system, deve… Read more Ids An Over-kill For A Single-user App?

INFORMIX-SQL 4.10.DC1 (SE Engine), on DOS 6.22, under Microsoft Virtual PC 2007, in Windows 7! EDIT… Read more What's The Fastest Way To Obtain The Maximum Value Of A Column In A Table?

Looking for a query in Informix's SQL that will simulate MySQL's group_concat function. Wha… Read more Group_concat In Informix

What's the most efficient way of getting the value of the SERIAL column after the INSERT statem… Read more Informix: How To Get An Id Of The Last Inserted Record

I have a column acdtime that gives me the time on a call in seconds. I need to transform those fiel… Read more Transform From Interval " 1:05:04" To Hh:mm Format Informix 11.50

INFORMIX-SQL or any other SQL-based DB: Suppose I have an app where depending on the value of some … Read more Variable Table Or Column Names

Informix 11.70.TC4: I have an SQL dimension table which is used for looking up a date (pk_date) and… Read more What Is The Best Way To Populate A Load File For A Date Lookup Dimension Table?

I have 2 Informix queries that I believe should return the same data but do not. The first query us… Read more 2 Queries That Should Return The Same Data But Don't

I have been trying to connect to an Informix database using a small program written in Java. The pr… Read more Informix Error On Running A Java Program

INFORMIX-SQL 4.10: OK, So after fixing the INTO TEMP syntax and using AS aliases, the ACE compiler … Read more Error Compiling Ace Report With Multiple Select Into Statements