|
 |
Remote Procedure Calls |
In the ViaSQL environment, a Remote Procedure Call (RPC) is a call
from Microsoft SQL Server or Sybase ASE to the ViaSQL Gateway component
of ViaSQL. The request sent by the RPC may be a SQL statement, a
TRANSFER statement, an RSP
(Remote Stored Procedure) call, or an XSP
(eXternal Stored Procedure) call. Results produced
from the request flow from ViaSQL, back to SQL Server, and then to the
client application. See some sample RPCs.
RPCs may be initiated by triggers, schedulers, or other SQL Server control
mechanisms. They can be used to ensure data integrity across platforms,
automate transfers, merge mainframe data with SQL Server data, or provide a single
login point for users. RPCs are also useful in
application partitioning,
providing a central location for application logic as well as data.
|
|
