Sybase 12.4.2 - Manual (Page 213)

CHAPTER 5 Moving Data In and Out of Databases
193
• 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. Adaptive Server IQ's remote data access
capabilities are currently supported on Windows NT only. For details, see
the Adaptive Server IQ Installation and Configuration Guide for Windows
NT.
Inserting directly from
an Adaptive Server
Enterprise database You can insert data easily from an Adaptive Server Enterprise or SQL Server
database, using the
LOCATION syntax of the INSERT statement. You can also
use this method to move selected columns from a pre-Version 12 Adaptive
Server IQ database into a Version 12 database.
In order to use this capability, all of the following must be true:
• The Sybase connectivity libraries must be installed on your system, and
the load library path environment variable for your platform must point to
them.
• The Adaptive Server Enterprise server to which you are connecting must
exist in the interfaces file on the local machine.
• You must have read permission on the source ASE or pre-Version 12 IQ
database, and INSERT permission on the target IQ 12 database
❖ To insert data directly from Adaptive Server Enterprise
1 Connect to both the Adaptive Server Enterprise and the Adaptive Server
IQ 12 database using the same user ID and password.
2 On the Adaptive Server IQ 12 database, issue a statement using this
syntax:
INSERT INTO asiq_table
LOCATION ’ ase_servername.ase_dbname’
{ SELECT col1, col2, col3,...
FROM owner.ase_table }
3 Issue a COMMIT to commit the insert.
Example The following command inserts data from the l_shipdate and l_orderkey
columns of the lineitem table from the Adaptive Server IQ 11.5 database
asiq11db.dba on the server detroit , into the corresponding columns of the
lineitem table in the current database.
INSERT INTO lineitem
(l_shipdate, l_orderkey)