Copying 1 table to training DB
Copying 1 table to training DB
(OP)
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
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
RE: Copying 1 table to training DB
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.