Sybase Technical Library - Product Manuals Home
[Search Forms] [Previous Section with Hits] [Next Section with Hits] [Clear Search] Expand Search

Chapter 11 Using
Destination-Template Transfer [Table of Contents] Chapter 13 Retrieving information with System
Procedures

Access Service User's Guide DirectConnect

[-] Chapter 12 Accessing catalog information with CSPs

Chapter 12

Accessing catalog information with CSPs

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 DB2 catalog and covers the following topics:

[-] General information
Why use CSPs
CSP properties
CSP set Statements
How the Access Service assembles stored procedure information
[+] Supported CSPs
[+] sp_fkeys
[+] sp_pkeys
[+] sp_server_info
[+] sp_special_columns
[+] sp_sproc_columns
[+] sp_statistics
[+] sp_stored_procedures
[+] sp_table_privileges
[+] sp_tables


Chapter 11 Using
Destination-Template Transfer [Table of Contents] General information