Chapter 3: Configuring a TRS

Using Catalog Stored Procedures (CSPs)

CSPs serve as a uniform catalog interface for accessing the system tables of different database management systems, including Adaptive Server.

Sybase provides CSPs that can be defined to TRS with MainframeConnect for DB2 UDB. These CSPs correspond to transactions on the mainframe that access the DB2 UDB catalog and return information to a client application in a standard format.

CSPs are implemented as CICS transactions and must be configured as RPCs to TRS. See Chapter 4, “Accessing Catalog Information with CSPs,” for configuration instructions.

The following table outlines the functions provided by CSPs and the four-character CICS transaction name that each procedure name maps to on the host.

**Table 3-7: CSP functions**
Procedure name	Related CICS transaction name	Function
sp_capabilities	SYBP	Returns information about the capabilities of the TRS
sp_columns	SYB3	Describes the columns of a table
sp_column_privileges	SYBA	Describes the column permissions of an object
sp_databases	SYB1	Lists the databases available
sp_datatype_info	SYBC	Describes the datatypes available
sp_fkeys	SYB8	Describes the primary key/foreign key relationships
sp_pkeys	SYB7	Describes the primary key for a table
sp_server_info	SYBB	Lists the configuration and capabilities
sp_special_columns	SYBD	Lists the optimal columns to uniquely identify rows and list columns that are automatically updated
sp_sproc_columns	SYB5	Describes the input/output of executable objects
sp_statistics	SYB6	Lists the index and statistics information about a table
sp_stored_procedures	SYB4	Lists the executable procedures
sp_table_privileges	SYB9	Describes the table permissions
sp_tables	SYB2	Lists the tables
sp_thread_props	SYBT	Returns minimal information at this time

For complete information about the mainframe installation, see the Mainframe Connect Installation and Administration Guide for DB2 UDB. For complete information about the syntax and operation of CSPs, see Chapter 4, “Accessing Catalog Information with CSPs,” in this guide.

View this book as PDF