A stored procedure is an application stored in an executable state and used by a server to access mainframe data. Stored procedures used with the DB2 UDB Option for CICS can be classified in three categories: remote procedure calls (RPCs), remote stored procedures (RSPs), and DB2 stored procedures.
Remote procedure call - An RPC is a stored procedure accessed indirectly through a client request and executed on a Server Option server. An RPC is a user-written program using the Server Option API.
Catalog stored procedure - A CSP is a set of RPCs that return system and table information and provide an interface for accessing system tables in a variety of database management systems.
Remote stored procedure - An RSP, like an RPC, is accessed indirectly through a client request. However, RSPs use the old MDI API, not the Server Option API.
DB2 stored procedure - A DB2 stored procedure is a user-written application invoked by the DB2 CALL command and executed inside DB2 address space.
The remainder of this chapter consists of the following subsections:
Copyright © 2005. Sybase Inc. All rights reserved. |
![]() |