Remote procedure calls (RPCs)

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

SQL Anywhere
Adaptive Server Enterprise
Oracle Database
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 and RETURN values:

[ UNSIGNED ] SMALLINT
[ UNSIGNED ] INTEGER
[ UNSIGNED ] BIGINT
[ UNSIGNED ] TINYINT
TIME
DATE
TIMESTAMP
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 or RETURNS values.
NUMERIC and DECIMAL data types are allowed for IN parameters, but not for OUT or INOUT parameters or RETURNS values.

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

Discuter à propos de cette page dans DocCommentXchange.