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.

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

View any function property page regardless of type – none.

Modify SQL code for Watcom SQL or Transact-SQL function – you must have 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 – you must have the CREATE EXTERNAL REFERENCE system privilege. You must also have one of:
  • ALTER ANY PROCEDURE system privilege
  • ALTER ANY OBJECT system privilege
  • You own the function
Modify a comment for any function type – you must have 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 – You must have 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, expand IQ Servers > Compiled Objects, and then select 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 you are modifying properties, you need not click Apply before changing screens; however, doing so saves any changes.
    • If you do not have privileges to modify properties, SAP 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. Do one of:
    • Click OK to update any changes to the database and exit the properties view.
    • Click Apply to update any changes to the database, but remain in the properties view.
    • Click Cancel to cancel any changes not updated to the database and exit the properties view.
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