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.

Prerequisites
Task
  1. In the Perspective Resources view, select the resource and select Resource > Administration Console.
  2. In the left pane of the Administration Console, expand IQ Servers > Other Objects and select Functions.
  3. In the right pane, select a function.
  4. Click the drop-down arrow that appears next to the function name and select Properties.
  5. View the contents of the properties dialog. You can modify some values:
    Page in Function Properties Modifiable Values
    General Comment
    Parameters None
    SQL SQL code
    Permission Permissions
  6. Click OK to save changes or click Cancel to dismiss the dialog without saving.
Related tasks
Listing Functions
Creating a Watcom SQL or Transact-SQL Function
Creating an External C/C++ Scalar or Aggregate Function
Creating an External Java Function
Granting or Revoking Permissions on a Function
Generating DDL for a Function
Deleting a Function