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

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - SQL Usage » Remote data access » Remote procedure calls (RPCs)

 

Creating remote procedures (Sybase Central)

Administrators can use Sybase Central to create a remote procedure.

Prerequisites

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.

 Create a remote procedure

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.

  1. Use the SQL Anywhere 16 plug-in to connect to the host database.

  2. In the left pane, double-click Remote Servers.

  3. Select the remote server, and in the right pane click the Remote Procedures tab.

  4. In the File menu, click New » Remote Procedure.

  5. Follow the instructions in the Create Remote Procedure Wizard.

Results

The remote procedure is created.

 See also