topic OpenSQL INSERT Subquery in Application Development and Automation Discussions

OpenSQL INSERT Subquery

Former Member — Mon, 15 Dec 2008 16:51:58 GMT

I'm looking to copy all records from one table and insert them into another identical table. I get the impression that this could be acheived using INSERT and a subquery SELECT but I can't seem to grasp it?

Any help would be much appreciated.

Re: OpenSQL INSERT Subquery

ThomasZloch — Mon, 15 Dec 2008 16:54:59 GMT

I have never heard that this could be done with just one open SQL statement (but that doesn't mean much).

I would select from one table into an internal table and insert that into the other one, using block processing in case the number of records is too large.

Probably an easier task if done directly down at the database level via native SQL.

Thomas

Re: OpenSQL INSERT Subquery

Former Member — Mon, 15 Dec 2008 17:21:07 GMT

If you are trying to do something like:

insert into ztab1 from 
  select * from ztab2.

I don't think this can be done in open SQL.

Rob

Re: OpenSQL INSERT Subquery

Former Member — Mon, 15 Dec 2008 19:42:35 GMT

To copy all the contents of one table into another identical table,we need to something like this.

select * from dbtab into correponding fileds of table itab.

Regards

Abhinab.