Copying 1 table to training DB

[gkrenton]

I have a table that I resides in my live DB but not in my test DB. I can't figure out what the sql syntax would be to copy the table from the one instance to the other.

MS Sql looks like it would be something like this

insert into ol_rentontrain.atb.ren_custom_tran
select * ol_renton.atb.ren_custom_tran

but not working in informix.

Any suggestions would be appreciated.

thanks

gina

 

[gumbie]

Hi Gina,

It's been a while since I've worked with Informix however I believe the following will work:

INSERT into remote_db@IDS_server_name:table_name
SELECT * from local_table_name;

HTH

Cheers,
-gumbie.