Adaptive server iq stored procedures – Sybase 12.4.2 User Manual

Page 28

Advertising
background image

Stored procedures

8

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

.

Advertising