Using IQ UTILITIES to Create Stored Procedures

The system stored procedures provided in SAP Sybase IQ are implemented in SQL.

You must use the local temporary table and IQ UTILITIES statement in exactly the same way as system stored procedures:

All SQL code for procedures is encrypted and compiled into the shared library libiqscripts16_r.so file on UNIX and iqscripts16.dll file on Windows.

Warning! Failing to use the statements correctly can cause serious problems for your IQ server or database.

To view the stored procedures code, enter sp_helptext 'owner.procname' in Interactive SQL.

The syntax for IQ UTILITIES is:

IQ UTILITIES MAIN INTO local-temp-table-name arguments

You may want to create your own variants of procedures. For example:

Create a procedure that calls a system stored procedure.
Create a procedure that is independent of the system stored procedures but performs a similar function.
Create a procedure that uses the same structure as the system stored procedures but provides additional functionality. For example to display procedure results in graphical form in a front-end tool or browser rather than as text.
If you choose either of the two previous options, make sure you understand the IQ UTILITIES statement and the strict requirements for using it.

IQ UTILITIES Command
IQ UTILITIES is the underlying statement that executes whenever you run most IQ system procedures. In most cases, users are unaware that IQ UTILITIES is executing. The only time IQ UTILITIES is issued directly by users is to run the IQ buffer cache monitor.
Choosing Procedures to Call
You can safely use IQ UTILITIES to create your own versions of documented system procedures that report on information in the database.
Numbers Used by IQ UTILITIES
Numbers are used as arguments in the IQ UTILITIES command. Each number is used in conjucntion with a system procedure.
Procedure Testing
To maintain the stability of your IQ server and database, test your procedures in a development environment before you run them in a production environment.

Parent topic: Procedures