Sybase 12.4.2 manual Adaptive Server IQ stored procedures, Stored procedures

Stored procedures

You can also create your own stored procedures. See Chapter 6, “Using

Procedures and Batches” for details.

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

Adaptive Server IQ stored procedures

The following procedures work specifically on the IQ Store. They are owned by the DBA user ID.

Note Stored procedures that produce size information assume that the database was created with the default block size, as described in “Block size”. If a database was created with a non-default block size, the output from the following stored procedures is inaccurate: sp_iqestjoin, sp_iqestdbspaces, sp_iqestspace.

8