Hi

If remote table is a table on a database server other than the current server. The general syntax for accessing a table on another informix server is: database@server:[owner.]table, so as you remeber, you can do:

INSERT INTO dbA@svrA:tableA

SELECT col1,col2 FORM any_table;

Syntax for MS SQL is [server\instance].[database].[schema].

, simple example:

INSERT INTO [svrA\instanceA].dbA.dbo.tableA

SELECT col1,col2 FORM any_table;

Regards

Mike