Remote procedure calls (RPCs)

SQL Anywhere users can issue procedure calls to the following remote servers:

SQL Anywhere
Adaptive Server Enterprise
Oracle
IBM DB2

SQL Anywhere supports fetching result sets from remote procedures, including fetching multiple result sets. As well, remote functions can be used to fetch return values from remote procedures and functions. Remote procedures can be used in the FROM clause of a SELECT statement.

Data types for remote procedures

The following data types are allowed for remote procedure call parameters:

[ UNSIGNED ] SMALLINT
[ UNSIGNED ] INT
[ UNSIGNED ] BIGINT
TINYINT
REAL
DOUBLE
CHAR
BIT
LONG VARCHAR, LONG NVARCHAR, and LONG BINARY data types are allowed for IN parameters, but not for OUT or INOUT parameters.
NUMERIC and DECIMAL data types are allowed for IN parameters, but not for OUT or INOUT parameters

Creating remote procedures (Sybase Central)
Creating remote procedures (SQL)
Dropping remote procedures

Discuss this page in DocCommentXchange.