Use one of the following procedures to issue a remote procedure call.
Remote procedures accept input parameters up to 254 bytes in length, and return up to 254 characters in output variables.
If a remote procedure can return a result set, even if it does not always return one, then the local procedure definition must contain a RESULT clause.
Use the SQL Anywhere 12 plug-in to connect to the host database as a user with DBA authority.
In the left pane, double-click Remote Servers.
Select the remote server, and in the right pane click the Remote Procedures tab.
From the File menu, choose New » Remote Procedure.
Follow the instructions in the Create Remote Procedure Wizard.
Connect to the host database as a user with DBA authority.
Execute a statement to define the procedure to SQL Anywhere. For example:
CREATE PROCEDURE RemoteWho() AT 'bostonase.master.dbo.sp_who';
The syntax is similar to a local procedure definition. The location string defines the location of the procedure.
For more information, see CREATE PROCEDURE statement.
Connect to the database as a user with DBA authority.
Execute the procedure as follows:
Discuss this page in DocCommentXchange.
|Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0|