Chapter 12: Retrieving Information with System Procedures


Understanding system procedures

System procedures are Sybase-supplied stored procedures that return information about the DB2 access service and the target database. This chapter describes the system procedures that a DB2 access service supports.

If a DB2 access service cannot support a procedure, that procedure returns a correctly formatted result set containing zero rows.

A client application initiates a system procedure in the same way that it initiates a CSP. For instructions to code both CSP and system procedures, see “Coding instructions”.