Administrators can use Sybase Central to create a remote procedure.
You must have the CREATE PROCEDURE system privilege to create procedures and functions owned by you. You must have the CREATE ANY PROCEDURE or CREATE ANY OBJECT privilege to create procedures and functions owned by others. To create external procedures and functions, you must also have the CREATE EXTERNAL REFERENCE system privilege.
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 16 plug-in to connect to the host database.
In the left pane, double-click Remote Servers.
Select the remote server, and in the right pane click the Remote Procedures tab.
In the File menu, click New » Remote Procedure.
Follow the instructions in the Create Remote Procedure Wizard.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|