Manage Procedures

Create, delete, display, and manage the properties of procedures in Sybase IQ, including table-valued user-defined functions and table parameterized functions.

Sybase provides sample procedures and functions with Sybase IQ. Sample procedures are visible in Sybase Control Center in the Administration Console (IQ Servers > Other Objects > Procedures). The samples include explanatory comments and can be found in IQ/IQ-X_X/samples/udf, where X_X is the Sybase IQ release number (15.4, for example).

• Listing Procedures
  Display a list of procedures available on Sybase IQ servers in this perspective.
• Creating a Procedure
  Set up a new procedure on a Sybase IQ server.
• Creating a Table UDF or Table Parameterized Function
  Set up an external table-valued user-defined function or table parameterized function in C/C++ or an external table-valued user-defined function in Java on a Sybase IQ server.
• Viewing and Modifying a Procedure
  Examine the SQL statement and properties of a procedure on a Sybase IQ server. You can edit the SQL statement and change some property values.
• Granting or Revoking Permissions on a Procedure
  Grant or revoke permission to execute a procedure on a Sybase IQ server.
• Generating DDL for a Procedure
  Generate the data description language for creating a procedure on a Sybase IQ server. The DDL code can be a useful reference and training tool.
• Deleting a Procedure
  Remove a procedure from a Sybase IQ server.