SAP ASE provides catalog stored procedures, system extended stored procedures (system
ESPs), and dbcc procedures.
- Catalog stored procedures – system procedures that retrieve information from the
system tables in tabular form.
- Extended stored procedures (ESPs) – call procedural language functions from SAP
ASE. The system extended stored procedures, created by
installmaster at installation, are located in the
sybsystemprocs database and are owned by the system
administrator. They can be run from any database and their names begin with
“xp_”.
- dbcc procedures – created by installdbccdb,
are stored procedures for generating reports on information created by dbcc
checkstorage. These procedures reside in the dbccdb
database or in the alternate database, dbccalt.