Procedures

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

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

• Creating a Procedure
  Set up a new procedure on an SAP Sybase IQ server.
• Creating a Remote Procedure
  Define a local alias for a procedure: a means of accessing a procedure on a remote server, through a local resource. Before you can map procedures from another server to the local alias, you must define the remote server where the procedure is located.
• Creating a Table UDF or TPF
  Set up an external table-valued user-defined function (Table UDF) or external table parameterized function (TPF) in C/C++, or an external table-valued user-defined function in Java (Java Table UDF) on an SAP Sybase IQ server.
• Executing a Procedure, Table UDF, or TPF using View Data in SQL
  Populate the Mini iSQL window with the result set of a selected procedure, remote procedure, Table UDF, or TPF.
• Deleting a Procedure, Table UDF, or TPF
  Remove a procedure, remote procedure, Table UDF, or TPF from an SAP Sybase IQ server.
• Generating Procedure, Table UDF, or TPF DDL Commands
  Generate the data description language for creating a procedure, remote procedure, Table UDF, or TPF on an SAP Sybase IQ server. The DDL code can be a useful reference and training tool.
• Viewing or Modifying a Procedure, Table UDF, or TPF
  Examine the SQL statement and properties of a procedure, remote procedure, Table UDF, or TPF on an SAP Sybase IQ server. You can edit the SQL statement and change some property values.
• Granting Procedure EXECUTE Permission
  Grant procedure execute permission to users and roles.
• Revoking Procedure EXECUTE Permission
  Remove procedure execute permission from users and roles.
• Procedure Privilege Summary
  A list of the system privileges and object permissions required to complete the various procedure tasks.