insert into local_table
select * from remote_table;

Any help here would be appreciated. Assume that sqlhosts is set up
and I have authority to access the remote server. I am running dbaccess
on the local server. what needs to be done to point to remote_table as far as syntax goes. Using IDS 7.31.

Thanks,

I have the answer... create a synonym pointing to remote database

thanks

here is the syntax

select * from databasename@informixservername:tablename

Cheers