Re: how to copy tables between databases

You can copy tables in DBAccess using the following syntax Pre-Requisites 1. You have to be in the target database in DBAccess INSERT INTO <TARGETTABLE> SELECT * FROM <SOURCEINSTANCE>@<SOURCEDATABASE>:<SOURCETABLE> Cheers Lijun Feng wrote in message <356E2254.140F@cis.ohio-state.edu>... >Hi Experts, > >I'm new to Informix. Here is one question: > >We have a database which has 10 tables including hundreds records. We >want to transfer or copy 6 of the 10 tables to another database, we want >to keep both table structure and records. Is there any easy way to do >this? In DBAccess? > >Thanks in advance. > >Lijun >-- > _/_/_/_/_/_/_/_/_/_/ Department of Computer & Information Science > _/ Lijun Feng _/ The Ohio State University >_/_/_/_/_/_/_/_/_/_/ Columbus, OH 43210