Access Service User's Guide DirectConnect for AS/400

CSP

Information Retrieved by the CSP

Location

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 (supported only in OS/400 version 3.1 or higher)

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_tables

List of tables, views, and system tables