Sybase IQ stored procedures help you manage your system. Stored procedures give you information about your database and users, and carry out various operations on the database. This section briefly describes the stored procedures. For more information, see the Chapter 7, “System Procedures” in Reference: Building Blocks, Tables, and Procedures.
A stored procedure typically operates on the database in which you execute it. For example, if you run the stored procedure sp_addlogin in the iqdemo database, it adds a user to iqdemo.
You can also create your own stored procedures. See Chapter 1, “Using Procedures and Batches,” in System Administration Guide: Volume 2 for details.
Statements shown in examples generally
use the iqdemo database, a sample database
that you can create using scripts installed with Sybase IQ.
