A stored procedure is a named collection of SQL statements or control-of-flow language. You can create stored procedures for commonly used functions, and to improve performance. Adaptive Server also provides system procedures for performing administrative tasks updating the system tables.
You can also create and use extended stored procedures to call procedural language functions from Adaptive Server. See Chapter 18, “Using Extended Stored Procedures.”