Adaptive Server Enterprise provides system and catalog procedures to carry out many administrative functions and to obtain system information. Sybase IQ has implemented support for some of these procedures.
System procedures are built-in stored procedures used for getting reports from and updating system tables. Catalog stored procedures retrieve information from the system tables in tabular form.
While these procedures perform the same functions as
they do in Adaptive Server Enterprise and pre-Version 12 Sybase IQ,
they are not identical. If you have preexisting scripts that use
these procedures, you may want to examine the procedures. To see
the text of a stored procedure, run
sp_helptext 'owner.procedure_name'
For all system stored procedures delivered by Sybase, the owner is dbo. To see the text of a stored procedure of the same name owned by a different user, you must specify that user, for example:
sp_helptext 'myname.myprocedure'
You may need to reset the width of your DBISQL output to see the full text, by clicking Command > Options and entering a new Limit Display Columns value.
