Inserting from a Different Database

You can insert data from tables in any accessible database.

Tables in either the IQ store or the catalog store of the database you are currently connected to.
Tables in an Adaptive Server Enterprise database.
A proxy table in your current database, that corresponds to a table in a database on a remote server.

Inserting Data Directly from Adaptive Server Enterprise
To insert data from an Adaptive Server Enterprise or SQL Server database, use the LOCATION syntax of the INSERT statement.

Parent topic: Inserting Selected Rows from the Database

Created August 28, 2013. Send feedback on this help topic to Technical Publications: pubs@sap.com