Chapter 11: Accessing Catalog Information with CSPs

Supported CSPs

The following table shows CSPs that a DB2 access service supports.

**Table 11-1: Supported CSPs**
CSP	Information retrieved by the CSP
sp_capabilities	Returns the SQL capabilities of a DB2 access service
sp_column_privileges	Column privilege information for one table
sp_columns	Column descriptions for a table
sp_databases	List of available databases
sp_datatype_info	Datatype descriptions
sp_fkeys	Foreign and primary key relationships
sp_pkeys	Primary key information for a single table
sp_server_info	Server terms, limits, and capabilities
sp_special_columns	Additional column information
sp_sproc_columns	Attributes of procedures input and return parameters
sp_statistics	Statistics and indexes for one table
sp_stored_procedures	List of available procedures
sp_table_privileges	Table privilege information for one table
sp_tables	List of aliases, synonyms, tables, views, and system tables