FORWARD TO statement
530
FORWARD TO statement
Use this statement to send native syntax SQL statements to a remote server.
FORWARD TO
server-name
{
sql-statement
}
FORWARD TO [
server-name
]
None
The remote connection is set to AUTOCOMMIT (unchained) mode for the
duration of the FORWARD TO session. Any work that was pending prior to
the FORWARD TO statement is automatically committed.
The FORWARD TO statement enables users to specify the server to which a
passthrough connection is required. The statement can be used in two ways:
♦
Syntax 1 Send a single statement to a remote server.
♦
Syntax 2 Place Adaptive Server Anywhere into passthrough mode for
sending a series of statements to a remote server. All subsequent
statements are passed directly to the remote server. To turn passthrough
mode off, issue FORWARD TO without a server-name specification.
If you encounter an error from the remote server while in passthrough
mode, you must still issue a FORWARD TO statement to turn
passthrough off.
When establishing a connection to server-name on behalf of the user, the
server uses:
♦ A remote login alias set using CREATE EXTERNLOGIN, or
♦ If a remote login alias is not set up, the name and password used to
communicate with Adaptive Server Anywhere
If the connection cannot be made to the server specified, the reason is
contained in a message returned to the user.
After statements are passed to the requested server, any results are converted
into a form that can be recognized by the client program.
server-name The name of the remote server.
sql-statement A command in the native SQL syntax of the remote server.
The command or group of commands is enclosed in curly brackets ({}).
♦
SQL/92 Entry-level feature.
♦
Sybase Supported by Open Client/Open Server.
Function
Syntax 1
Syntax 2
Permissions
Side effects
Description
Standards and
compatibility
To Next Page
Loading...