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 (SQL)

You can create remote procedures and functions in Interactive SQL.


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.

Contexte et remarques

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.

 Create a remote procedure
  1. Connect to the host database.

  2. Execute a statement to define the procedure or function.

    For example:

    AT 'bostonase.master.dbo.sp_proc';
    CREATE FUNCTION RemoteFunc()
    AT 'bostonasa..dbo.sp_func';

    The syntax is similar to a local procedure definition. The location string defines the location of the procedure.


The remote procedure or function is created.


This example specifies a parameter when calling a remote procedure:

CREATE PROCEDURE RemoteUser ( IN username CHAR( 30 ) )
AT 'bostonase.master.dbo.sp_helpuser';
CALL RemoteUser( 'joe' );

This example creates an interface to a function defined at the remote server RemoteSA:

CREATE FUNCTION proxy_maxorder()
AT 'RemoteSA;;DBA;maxorder';
 See also