A server configured with RPCServer is not capable of handling anything other than RPCs. Servers in this class cannot participate in distributed transactions, and Component Integration Services does not attempt to send SQL statements to a server configured with this class.
To send RPCs to Backup Server or to XP Server, the sp_serveroption negotiated logins and server logins must be enabled.
Typically, servers in this class are customer-written Open Server applications intended to either perform a customized operation, or to make data available to an Adaptive Server application that is generated as a result of one or more RPCs. The only Open Server event handlers required for this type of application are:
SRV_CONNECT – handle and authenticate a login request from CIS or client application.
SRV_DISCONNECT – handle disconnect request from CIS or client application.
SRV_ATTENTION – handle CANCEL request from CIS or client application.
SRV_RPC – handle RPC from CIS. The handling of the RPC may produce a result set, which CIS will forward to the ASE client on whose behalf CIS forwarded the RPC.
Using this server class, it is possible to write an Open Server application that supports CIS proxy tables that map to RPC's:
create existing table myRPCtable ( <column description(s) ) external procedure at 'myRpcServerName...rpcname'