System Procedures

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

Sybase IQ includes the following kinds of system procedures:

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

• 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 Sybase IQ at the time the procedure executes.
• System Stored Procedures
  System stored procedures carry out System Administrator tasks in the IQ main store.
• 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. Sybase IQ supports some of these procedures.
• SQL Anywhere Supported Procedures
  Sybase IQ supports the SQL Anywhere system procedures.