Supported CSPs

Table 4-2 shows the supported CSPs and the information that each CSP retrieves:

Table 4-2: 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

The following sections provide descriptions, syntax, parameters, and usage for the supported CSPs.