| |
Home |
![[Table of Contents]](/dwicons/b_toc.gif)
|
Access Service User's Guide DirectConnect for AS/400 |
![[-]](/dwicons/i_colpse.gif)
| Chapter 12 Accessing catalog information with CSPs |
Chapter 12
To obtain information about database objects, you need to access the database catalog. Catalog Stored Procedures (CSPs) provide this catalog access. This chapter describes how to use CSPs to access the AS/400 catalog and covers the following topics:
All references to Adaptive Server 12.0 apply to SQL Server 11.1 and later, unless otherwise indicated.
|
| General information |
| CSP properties |
| How the Access Service assembles stored procedure information |
| Supported CSPs |
|
| Coding instructions |
| Parameters |
| Syntax |
![[+]](/dwicons/i_expand.gif)
| Coding examples |
|
| sp_columns |
| Description |
| Syntax |
| Parameters |
|
| Usage |
|
| sp_databases |
| Description |
| Syntax |
| Parameters |
|
| Usage |
|
| sp_datatype_info |
| Description |
| Syntax |
| Parameters |
|
| Usage |
|
| sp_fkeys |
| Description |
| Syntax |
| Parameters |
|
| Usage |
|
| sp_pkeys |
| Description |
| Syntax |
| Parameters |
|
| Usage |
|
| sp_server_info |
| Description |
| Syntax |
| Parameters |
|
| Usage |
|
| sp_special_columns |
| Description |
| Syntax |
| Parameters |
|
| Usage |
|
| sp_sproc_columns |
| Description |
| Syntax |
| Parameters |
|
| Usage |
|
| sp_statistics |
| Description |
| Syntax |
| Parameters |
|
| Usage |
|
| sp_stored_procedures |
| Description |
| Syntax |
| Parameters |
|
| Usage |
|
| sp_tables |
| Description |
| Syntax |
| Parameters |
|
| Usage |
|
|