Stored procedures

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 Sybase IQ Reference Manual.

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 asiqdemo database, it adds a user to asiqdemo.

You can also create your own stored procedures. See Chapter 8, “Using Procedures and Batches” for details.

NoteStatements shown in examples generally use the asiqdemo database, a sample database installed as part of Sybase IQ. For a diagram of this database’s structure, see Introduction to Sybase IQ.