Is there anything inherently bad about using derived tables in
Informix world?
select
   activity.id,

I'm trying to query a table (lets call it "InvoicesTable") and I would
like to include the invoices last update remark by the employee whose
managing the invoice. In sql, I would probably do a subquery, using
the TOP function, but informix doesn't seem to allow you to use the

We have a vendor product and in their informix database, they have
their date, time and seconds separated in 3 different columns.
item_date (date field)
item_time (smallint field)

Is anybody using IDS on HP-UX Itanium, particularly with EMC Clariion?
Would ove to swap stories and compare notes.  Please send me a private.
thx
N

Is there a solution for this warning from SSIS 2008?
 Cannot retrieve the column code page info from the OLE DB Provider
Setting AlwaysUseDefaultCodePage to TRUE didn't fix it.

We have a lot of columns of type char and going to change them to
varchar where we expect to have a lot of trailing blanks in.
Because we do not want NULL values we cannot directly use rtrim().
So to get at least one blank the function we use is this:

I have a couple of doubts about a recommendation from IBM, related to
NETTTPE parameter:
NETTYPE protocol,poll_threads,connections,VP_class
** The first one is about "connections". This is per poll_thread or

I'm reading on c.d.i UseNet.  It seems that there are replies that are
referenced that I don't see.  Is there an issue with the gateway?
JWC

I'm running IDS Server 11.50.FC5W4 using Solaris SPARC 10 on a SunBlade
2000 workstation with two 1.2 GHz CPUs and 8 GB of memory.
The export size of the database to import is 22 GB.
The dbimport took about 16 h in total, 13 h for data loading and 3 h for

Dear Informix Users,
Marriott Overland Park (Kansas City Area), Kansas, USA April 25-28,
2010
http://www.iiug.org

I've never done IDS upgrades before so hence this question:
Can an IDS version 10.00FC4 upgrade to 11.50 directly or do you have
to upgrade version 10 to FC10?

I am running IDS 11.50.FC4 and am trying to use the SQL Admin Api to
add logical logs after the current log.  However it does not add the
log after the current log.  It adds it to the end of the list.  I want
to add a few large logs for batch processing, backup the logs, then