All syntax is supported. Since the remote server is assumed to have all capabilities necessary to process Transact-SQL syntax, all elements of a select command, except those mentioned above, are forwarded to a remote server, using quickpass mode.
A bulk copy transfer is used to copy data into the new table when a select...into command is issued and the into table resides on a remote Adaptive Server. Both the local and remote databases must be configured with dboption set to select into / bulkcopy.
All syntax is supported. Since the remote server is assumed to have all capabilities necessary to process Transact-SQL syntax, all elements of a select command, except those mentioned above, are forwarded to a remote server, using quickpass mode.
If the select...into format is used and the into table is accessed through the ASAnywhere interface, bulk inserts are not used. Instead, Component Integration Services uses Client-Library to prepare a parameterized dynamic insert command, and executes it for each row returned by the select portion of the command.
All syntax is supported. Since the remote server is assumed to have all capabilities necessary to process Transact-SQL syntax, all elements of a select command, except those mentioned above, are forwarded to a remote server, using quickpass mode.
The first time Component Integration Services requires a connection to a server in class direct_connect, a request for capabilities is made of the DirectConnect. Based on the response, Component Integration Services determines the parts of a select command to forward to the DirectConnect. In most cases, this is determined by the capabilities of the DBMS with which the DirectConnect is interfacing.
If the entire statement cannot be forwarded to the DirectConnect using quickpass mode, Component Integration Services compensates for the functionality that cannot be forwarded. For example, if the remote server cannot handle the order by clause, quickpass is not used and Component Integration Services performs a sort on the result set.
Component Integration Services passes data values as parameters to either a cursor or a dynamic SQL statement. Language statements can also be used if the DirectConnect supports it. The parameters are in the datatype native to Adaptive Server and must be converted by the DirectConnect into formats appropriate for the target DBMS.
The select...into command is supported, but the table must have a unique index if the table has text or image columns.
If the select...into format is used and the into table is accessed through a DirectConnect, bulk inserts are not used. Instead, Component Integration Services uses Client-Library to prepare a dynamic insert command, and executes it for each row returned by the select portion of the command.
select in the Reference Manual
