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

SQL Anywhere 12.0.1 » SQL Anywhere Server - SQL Usage » Remote data and bulk operations » Remote data access » Remote procedure calls (RPCs)

 

Creating remote procedures (SQL)

Administrators can create remote procedures in Interactive SQL.

Prerequisites

DBA authority.

Context and remarks

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 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.

Results

The remote procedure is created.

Next

None

Example

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' );

 See also