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.

Prerequisites
Database Version Function Privileges
SAP Sybase IQ 15.3 and 15.4 None.
SAP Sybase IQ 16.0 None.
Task
  1. In the Perspective Resources view, select the resource, and select Resource > Administration Console.
  2. In the left pane, expand IQ Servers > Compiled Objects, and then select Functions.
  3. Select one or more functions from the right pane and either:
    • Click the arrow to the right of the name and select Generate DDL, or
    • From the Administration Console menu bar, select Resource > Generate DDL.
    Tip: Use Shift-click or Control-click to select multiple functions.
    The DDL view shows the SQL code used to add the selected functions.
Related tasks
Creating a Watcom SQL or Transact-SQL Function
Creating an External Java Function
Creating an External C/C++ Scalar or Aggregate Function
Deleting a Function
Viewing and Modifying a Function
Granting Function EXECUTE Permission
Revoking Function EXECUTE Permission
Authenticating a Login Account for a Managed Resource
Related reference
Function Privilege Summary