Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Usage » Accessing Remote Data

Joining tables from multiple local databases Next Page

Sending native statements to remote servers

Use the FORWARD TO statement to send one or more statements to the remote server in its native syntax. This statement can be used in two ways:

The FORWARD TO statement can be used to verify that a server is configured correctly. If you send a statement to the remote server and SQL Anywhere does not return an error message, the remote server is configured correctly.

The FORWARD TO statement cannot be used within procedures or batches.

If a connection cannot be made to the specified server, a message is returned to the user. If a connection is made, any results are converted into a form that can be recognized by the client program.

For more information, see FORWARD TO statement.

Example 1

The following statement verifies connectivity to the server named RemoteASE by selecting the version string:

FORWARD TO RemoteASE {SELECT @@version};
Example 2

The following statements show a passthrough session with the server named RemoteASE:

SELECT * FROM titles
SELECT * FROM authors