Supported CSPs

Table 11-1 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