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 - 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 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 - 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 user-written application invoked by the DB2 CALL command and executed inside DB2 address space.
The remainder of this chapter describes each of these procedures.
