I'm working on a database migration tool from Informix to SQL Server.
I'm looking for Informix databases (schema only no data needed) that
I can try my tool on and take them as a test case.
If anyone can provide me with a database  schemas that  are complex

Is anyone aware of any way of compressing the data using IConnect or
any middleware?
In our current environment, we have quite a few clients connected to
our 9.4 IDS via WAN.

Could anyone provide any guid what is the most practical way to migrate
4gl application running against IDS so that it run against SQL Server ?
Even if you do a total rewrite is there any way to use some of the
existing logic ?

Good Day
I have an application that is using an informix jdbc connection pool.
Intermittantly I get the error java.net.SocketException: Socket closed
when trying to do connection.close()

DBA's,
I have 180 user licenses for IBM Informix Dynamic Server Version 10.00.FC3R1 for a
HP 9000/800/N4000-65.  The application accesses the instance by RFID devices though tcp/ip connections. My client wants to be able to access the application from several PC's as well.
My ...

What script or tool do you use to benchmark a server for OLTP?  I'm
trying to decide on the best RAID and fragmentation strategy for a new
system and I need something that can simulate a large load coming from
many users (300).  I've had a look around and found a few free or

 how can I delete all rows from standard (with loggin) table on IDS 9.40?
 - on  tuncate table [table_name]  server report synstax error (SQL
State: 42000, Error Code: -201)
 - on  delete from [table_name]  causes long transaction error (SQL

Using 4GL (7.20) I am looking for a way of doing the equivalent of a
shared table lock on a row.
The idea is to prevent a user coming along and taking an exclusive lock
on the row (and updating the information), but at the same time allowing

I'm back.. :)
consider always I'm newbie in Informix DB...
I have probably to upgrade IDS 9.40 xC2 (TC2) to xC3 or later..
now I wonder if this can prejudice the integrity of data exported form

I'm looking for Marketing data on how application(home grown
application not
packaged application) that is written on top of Informix interact with
the

I'm trying to connect ASP pages (working under IIS6) to informix db (working
in Suse Linux Environment),
using this string:
<%

We  use raws   stripped disk. IDS10 UC5, AIX 5.3
onspaces utility runing very slow, how can we speed  it up?
example,
onspaces -c -d dbphylog -p /usr/informix/dev-links/int1/DBPHYLOG_INT1 -o

Do you know in which version the onprobe utility was taken off. I do not see
it in (.40 but I can see it in 7.31?
Thanks
Basim Chafik

I am doing dbimport and bumped with the error,
create unique index "informix".user_email_idx on "informix".user_email
   (user_id,email_id) using btree  in dbdata00 ;
*** execute sqlobj

I met with a strange problem. I have a script to load data from a text
file into a table. On the first run, I hit with an error said that the
number of columns mismatch. But, when I tried another time with the
same source file, i received no error. Is there any explanation to this