The following pages are reference pages, presented in alphabetical order, which discuss Transact-SQL commands that either 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 described. For a complete description of each command, see the Adaptive Server 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:
Function - contains a brief description of the command.
Syntax - contains a description of the full Transact-SQL syntax of the command.
Comments - 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 sql_server - contains a description of handling specific to server class sql_server. This includes syntax that is forwarded to a remote server of class sql_server.
Server Class direct_connect - contains a description of handling specific to server class direct_connect (access_server). This includes syntax that is forwarded to a remote server of class direct_connect (access_server). In this release, all comments that apply to server class direct_connect, also apply to server class sds.
Server Class db2 - contains a description of handling specific to server class db2. This includes syntax that is forwarded to a remote server of class db2.
