Functions

Create, delete, display, and manage the properties of functions in SAP Sybase IQ.

Sample functions and procedures are provided with SAP Sybase IQ. Sample functions are visible in Sybase Control Center in the Administration Console (IQ Servers > Compiled Objects > Functions. 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 Watcom SQL or Transact-SQL Function
  Set up a new Watcom SQL or Transact-SQL function on an SAP Sybase IQ server.
• Creating an External Java Function
  Set up a new external Java function on an SAP Sybase IQ server.
• Creating an External C/C++ Scalar or Aggregate Function
  Set up a new external C or C++ aggregate function on an SAP Sybase IQ server.
• Deleting a Function
  Remove a function from an SAP Sybase IQ server.
• Generating Function DDL Commands
  Generate the data description language for creating a function on an SAP Sybase IQ server. The DDL code can be a useful reference and training tool.
• Viewing and Modifying a Function
  View and change the SQL statement and properties of a function on an SAP Sybase IQ server.
• Granting Function EXECUTE Permission
  Grant function execute permission to users and roles.
• Revoking Function EXECUTE Permission
  Remove function execute permission from users and roles.
• Function Privilege Summary
  A list of the system privileges and object permissions required to complete the various function tasks.