System Procedures

Use the system-supplied stored procedures in SAP Sybase IQ databases to retrieve system information.

SAP Sybase IQ includes the following kinds of system procedures:

System functions that are implemented as stored procedures.
Catalog stored procedures, for displaying system information in tabular form.
Multiplex stored procedures, which include both of the above types of procedures, for multiplex server operations. See System Procedures in Administration: Multiplex.
Transact-SQL system and catalog procedures.

System stored procedures related specifically to Large Object data, including sp_iqsetcompression and sp_iqshowcompression, are described in Stored Procedure Support in Unstructured Data Analytics.

Managing Privileged System Procedure Execution
There are two security models under which privileged system procedures can run. Each model grants the ability to run the system procedure differently.
Syntax Rules for Stored Procedures
Use of parentheses and quotes in stored procedure calls varies, depending on whether you enter the procedure name directly, as you can in Interactive SQL, or invoke it with a CALL statement.
Understanding Statistics Reported by Stored Procedures
Many stored procedures report information on the state of SAP Sybase IQ at the time the procedure executes.
SQL Anywhere Supported Procedures
SAP Sybase IQ supports SQL Anywhere system procedures.
Alphabetical List of System Stored Procedures
System stored procedures carry out System Administrator tasks in the IQ main store.
Alphabetical List of Catalog Stored Procedures
Catalog store stored procedures return result sets displaying database server, database, and connection properties in tabular form.
Adaptive Server Enterprise System and Catalog Procedures
Adaptive Server Enterprise provides system and catalog procedures to carry out many administrative functions and to obtain system information. SAP Sybase IQ supports some of these procedures.