Manage Functions

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

Sybase provides sample functions and procedures with Sybase IQ. Sample functions are visible in Sybase Control Center in the Administration Console (IQ Servers > Other Objects > Functions and 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 Functions
  Display a list of functions available on Sybase IQ servers in this perspective.
• Creating a Watcom SQL or Transact-SQL Function
  Set up a new Watcom SQL or Transact-SQL function on a Sybase IQ server.
• Creating an External C/C++ Scalar or Aggregate Function
  Set up a new external C or C++ aggregate function on a Sybase IQ server.
• Creating an External Java Function
  Set up a new external Java function on a Sybase IQ server.
• Viewing and Modifying a Function
  Examine the SQL statement and properties of a function on a Sybase IQ server. You can edit the SQL statement and change some property values.
• Granting or Revoking Permissions on a Function
  Grant or revoke permission to execute a function on a Sybase IQ server.
• Generating DDL for a Function
  Generate the data description language for creating a function on a Sybase IQ server. The DDL code can be a useful reference and training tool.
• Deleting a Function
  Remove a function from a Sybase IQ server.