Hi,

I have some tables which are in a database of 1 informix database server (say prodServer)

I need to fetch data from tables in the prodServer and write into tables in another informix database server (say QAServer).

The 2 servers have database connectivity with each other.

My sql scripts will be in the QAServer.

I would greatly appreciate your help. Thank you.

sjalis

insert into table table_zyx
select * from db1@prodServer:table_xyz

If you need some logical process on data transfered from prodSever, maybe you need write a SPL (Stored Procedure) and work with cursors, variables, ifs,foreachs,....
More about SPL, read the Informix SQL Syntax Manual...