The system stored procedures provided in Sybase IQ are implemented in SQL, using the methods described in the rest of this chapter.
You must use the local temporary table and IQ UTILITIES statement in exactly the same way as system stored procedures:
Violating these rules can cause serious problems for your IQ server or database.
All SQL code for procedures is encrypted and compiled into the shared library libiqscripts15_r.so file on Unix and iqscripts15.dll file on Windows.
You can view the stored procedures code by using Sybase Central or by entering sp_helptext 'owner.procname' in Interactive SQL.
IQ UTILITIES MAIN INTO local-temp-table-name arguments
The IQ UTILITIES command is only documented in Reference: Statements and Options to the IQ monitor, because of the strict requirements for its use and the risk to system operations if it is used incorrectly.
You may want to create your own variants of some of these procedures. Among the ways you might do this are: