OpenSQL INSERT Subquery

[Former Member]

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.

[ThomasZloch]

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

[Former Member]

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

[Former Member]

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.