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 increase performance. Adaptive Server also provides system procedures to perform administrative tasks and to update 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.”