Contents Index Joining tables from multiple local databases Using remote procedure calls (RPCs)

ASA SQL User's Guide
  Accessing Remote Data

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:

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

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 Adaptive Server Anywhere does not return an error message, the remote server is configured correctly.

For more information, see FORWARD TO statement.

Example 1 

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

FORWARD TO ASEserver {SELECT @@version}
Example 2 

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

FORWARD TO ASEserver
select * from titles
select * from authors
FORWARD TO

Contents Index Joining tables from multiple local databases Using remote procedure calls (RPCs)