The following pages discuss, in alphabetical order, Transact-SQL commands that directly or indirectly affect external tables, and, as a result, Component Integration Services. For each command, a description of its effect on Component Integration Services, and the manner in which Component Integration Services processes the command is provided. For a complete description of each command, see the Reference Manual.
If Component Integration Services does not pass all of a command’s syntax to a remote server (such as all clauses of a select statement), the syntax that is passed along is described for each server class.
Each command has several sections that describe it:
Description – contains a brief description of the command.
Syntax – contains a description of the full Transact-SQL syntax of the command.
Usage – contains a general, server class-independent description of handling by Component Integration Services.
Server class ASEnterprise – contains a description of handling specific to server class ASEnterprise. This includes syntax that is forwarded to a remote server of class ASEnterprise.
Server class ASAnywhere – contains a description of handling specific to server class ASAnywhere. This includes syntax that is forwarded to a remote server of class ASAnywhere.
Server class ASIQ – contains a description of handling specific to server class ASIQ. This includes syntax that is forwarded to a remote server of class ASIQ.
Server class direct_connect – contains a description of handling specific to server class direct_connect. This includes syntax that is forwarded to a remote server of class direct_connect. In this release, all comments that apply to server class direct_connect, also apply to server class sds.
