Catalog Stored Procedures

Catalog stored procedures retrieve information from the system tables in tabular form. Created by installmaster at installation, they are located in the sybsystemprocs database and are owned by the system administrator.

Many of them can be run from any database. If a catalog stored procedure is executed from a database other than sybsystemprocs, it retrieves information from the system tables in the database from which it was executed.

All catalog stored procedures execute at isolation level 1.

All catalog stored procedures report a return status. For example, this means that the procedure executed successfully. The examples in this book do not include the return status:
return status = 0