Viewing and Modifying a Function

View and change the SQL statement and properties of a function on an SAP Sybase IQ server.

Prerequisites
Database Version Function Privileges
SAP Sybase IQ 15.3 and 15.4

View any function property page regardless of type – None required.

Modify permissions for any function type – Requires one of:
  • DBA authority.
  • PERMS ADMIN authority.
  • You own the database object.
Modify any other function property regardless of type – Requires one of:
  • DBA authority.
  • You own the function.
SAP Sybase IQ 16.0

View any function property page regarless of type – None required.

Modify SQL code for Watcom SQL or Transact-SQL function – Requires one of:
  • ALTER ANY PROCEDURE system privilege.
  • ALTER ANY OBJECT system privilege.
  • You own the function.
Modify SQL code for External C/C++ Scalar or Aggregate, or External Java function – Requires one of:
  • Requires CREATE EXTERNAL REFERENCE system privilege.
  • Also requires one of:
    • ALTER ANY PROCEDURE system privilege.
    • ALTER ANY OBJECT system privilege.
    • You own the function.
Modify a comment for any function type – Requires one of:
  • CREATE ANY PROCEDURE system privilege.
  • ALTER ANY PROCEDURE system privilege.
  • CREATE ANY OBJECT system privilege.
  • ALTER ANY OBJECT system privilege.
  • COMMENT ANY OBJECT system privilege.
  • You own the function.
Modify permissions for any function type – Requires one of:
  • MANAGE ANY OBJECT PRIVILEGE system privilege.
  • You own the database object.
Task
  1. In the Perspective Resources view, select the resource and select Resource > Administration Console.
  2. In the left pane, select IQ Servers > Compiled Objects > Functions.
  3. Select a function from the right pane and either:
    • Click the arrow to the right of the name and select Properties, or
    • From the Administration Console menu bar, select Resource > Properties.
    The Function Properties view appears.
  4. View or modify the properties.
    • When modifying properties, clicking Apply before changing screens is not necessary, but will save any changes.
    • If you do not have privileges to modify properties, Sybase Control Center displays the properties view in read-only mode.
    Area Description
    General

    Name – (Read-only) The name of the function.

    Owner – (Read-only) The owner of the function.

    Creation Time – (Read-only) The date and time the function was created.

    Dialect – (Read-only) The dialect of the function. Valid values are:
    • Watcom-SQL
    • Transact-SQL
    • External C/C++ scalar
    • External C/C++ aggregate
    • External Java

    Comment – A text field for adding an optional comment about the function.
    Parameters

    (Read-only)

    		 The parameters defined from the function.
    SQL The SQL code to be executed by the function.
    Permissions

    See Granting Function EXECUTE Permission and Revoking Function EXECUTE Permission
  5. Click OK.
Parent topic: 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
Generating Function DDL Commands
Granting Function EXECUTE Permission
Revoking Function EXECUTE Permission
Authenticating a Login Account for a Managed Resource
Related reference
Function Privilege Summary