FORWARD TO Statement

Sends native syntax to a remote server.

Syntax

Syntax 1

FORWARD TO server-name { sql-statement }

Syntax 2

FORWARD TO [ server-name ]

Examples

Example 1 – A passthrough session with the remote server ase_prod:

FORWARD TO aseprod
SELECT * from titles
SELECT * from authors
FORWARD TO

Usage

FORWARD TO enables users to specify the server to which a passthrough connection is required. The statement can be used:

To send a statement to a remote server (Syntax 1)
To place SAP Sybase IQ into passthrough mode for sending a series of statements to a remote server (Syntax 2)

When establishing a connection to server-name on behalf of the user, the server uses:

A remote login alias set using CREATE EXTERNLOGIN
If a remote login alias is not set up, the name and password used to communicate with SAP Sybase IQ

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 is the name of the remote server.

sql-statement is a command in the native syntax of the remote server. The command or group of commands is enclosed in curly braces ({}) or single quotes.

When you specify a server_name, but do not specify a statement in the FORWARD TO query, your session enters passthrough mode, and all subsequent queries are passed directly to the remote server. To turn passthrough mode off, issue FORWARD TO without a server_name specification.

Note: The FORWARD TO statement is a server directive and cannot be used in stored procedures, triggers, events, or batches.

Side Effects

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.

Standards

SQL—ISO/ANSI SQL compliant.
Sybase—Supported by Open Client/Open Server.

Permissions

None