The copy from table to table statement copies the contents of matching fields from one table buffer to another. Non-matching fields aren’t affected.
copy from table source_table to table destination_table
• source_table – The name of the table buffer you want to copy the field contents from.
• destination_table – The name of the table buffer you want to copy the field contents to.
Fields are matched based upon their field IDs. This means a specific field in the source table and a specific field in the destination table must use the same global field resource in order to match.
The copy from table to table statement is useful for copying records from one table to another. A procedure using anonymous tables can be set up to allow transferring records between tables that will be specified when your application is running.