Recent posts

Enterprise replication between two databases

Hi,

I would like to configure an enterprise replication between two databases (for only specific tables) in one single database server. Can this be accomplished by creating an alias name for the dbserver and using the actual dbservername and the dbserveralias to start replication?

I.e., DBSERVER=ids_em, DBSERVERALIAS=ids_em_alias, 1st db=test, 2nd db=test1,...



Read more
banks_m35 Written on 07/22/2011 in Question

Problems with Windows Vista SP2 Updates

Hi there, I am using Dell Inspiron laptop and MS Windows Vista together with SP2 is running on it.

I encounter a problem with Windows Updates so that I search some suggestions in several forums.  Some suggestions are tried and I understand that I can use a program...



Read more
Markony Written on 07/22/2011 in Question

Execute SQL query ever end of month

Hi,

I am using the Informix database with dbaccess data_base_name. Could you please let me know how to execute a SQL query every month end without modification of the query? For example every end of month I have a dozen of SQL queries to be executed and I have...



Read more
bakerj82 Written on 07/22/2011 in Question

IeXplore caused a stack fault in module Wsock32.dll

Hi!

When I start or shutdown my computer, it attempts to start a program, or attempt to connect to the Internet, I am receiving the following error message:

Mtx_ caused an invalid page fault in module mtx_.exe

I2Xplore caused a stack fault in module...



Read more
Markony Written on 07/22/2011 in Question

Return data type of aggregate function

Good day,

I am working on converting windows applications, so it can be used with SQL server and Informix database. In a SQL server, the return data type of the SUM () function is the same as the data type of the column begin summed. So, if I sum integer...



Read more
hkody91 Written on 07/22/2011 in Question

Better Performance of DISTINCT and GROUP BY

Hello,

I am confused. DISTINCT or GROUP BY which one has a better performance in Informix database? I am new to the Informix database. By the way, in my Select query there is no aggregate function. It’s a direct Select query with WHERE clause and I used DISTINCT,...



Read more
a_kim34 Written on 07/22/2011 in Question

Informix load/unload problem with UTF-8

Hi all,

I am working with two databases in Informix 10. Each one is on a different machine and I am trying to copy some data from one table to an identical table in the other database. Both...



Read more
b.jai75 Written on 07/22/2011 in Question

The site didn’t send the forgotten password.

Hi i forgot my password and i gave my email address for that login id but this site didn't email me new or my forgotten password.



Read more
mominagha Written on 07/22/2011 in Question

Data Migration from Informix database to oracle database

Hi experts,

I would like someone to help me with migration that I must execute soon. I will migrate an older Informix database to a newer Oracle 11g database. This is my first big migration experience and I have some questions.

First, I would like to know if Oracle Migration workbench already does what Oracle...



Read more
garfieldc14 Written on 07/22/2011 in Question

Windows 7 Recovery virus error

Hi there, Since MS Windows 7 was installed on the laptop, MS Windows 7 Recovery from Virus was downloaded this weekend.  However, after the installation all photos, programs and documents were hidden. 

I tried to Google the solution and an expert suggested the use of Grindsoft Trojan Killer...



Read more
Morrison boyd Written on 07/22/2011 in Question