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:
To send a statement to a remote server
To place Sybase IQ into passthrough mode for sending a series of statements to a remote server
If a connection cannot be made to the specified server, the reason is contained in a message returned to the user. 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 Sybase IQ does not return an error message, the remote server is configured correctly.
The following statement verifies connectivity to the server named ASEserver by selecting the version string:
FORWARD TO ASEserver {SELECT @@version}
The following statements show a passthrough session with the server named ASEserver:
FORWARD TO ASEserver select * from titles select * from authors FORWARD TO
The FORWARD TO statement without a servername turns off passthrough mode. For more information, see FORWARD TO statement in the Sybase IQ Reference Manual.
