The system stored procedures provided in Sybase IQ are implemented in SQL, using the methods described in the rest of this chapter. You may wish to create your own variants of some of these procedures. Among the ways you might do this are:
Create a procedure that calls a system stored procedure. The sp_iq_process_login procedure in Sybase IQ Reference Manual is an example of this method.
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, you might want to display procedure results in graphical form in a front-end tool or browser rather than as text.
If you choose the second or third option, you need to understand the IQ UTILITIES statement and the strict requirements for using it.
