Viewing or Modifying a Procedure, Table UDF, or TPF

Examine the SQL statement and properties of a procedure, remote procedure, Table UDF, or TPF on an SAP Sybase IQ server. You can edit the SQL statement and change some property values.

Prerequisites
Database Version Procedure Privileges
SAP Sybase IQ 15.3 and 15.4

View any procedure property page regardless of type – none.

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

View any procedure property page regardless of type – none.

Modify SQL code for Watcom-SQL or Transcat-SQL procedures – you must have one of:
  • ALTER ANY PROCEDURE system privilege
  • ALTER ANY OBJECT system privilege
  • You own the procedure
Modify SQL code for Table UDFs, TPFs, or External Environment procedures – 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 procedure
Modify a comment for any procedure 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 procedure
Modify permissions for any procedure 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 Procedures.
  3. Select a procedure 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 Procedure 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 procedure.

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

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

    Dialect – (Read-only) The dialect of the procedure. 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 procedure.

    Parameters

    (Read-only)    		 The parameters defined from the procedure.
    SQL The SQL code to be executed by the procedure.
    Permissions

    See Granting Procedure EXECUTE Permission and Revoking Procedure 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: Procedures
Related tasks
Creating a Procedure
Creating a Remote Procedure
Creating a Table UDF or TPF
Executing a Procedure, Table UDF, or TPF using View Data in SQL
Deleting a Procedure, Table UDF, or TPF
Generating Procedure, Table UDF, or TPF DDL Commands
Granting Procedure EXECUTE Permission
Revoking Procedure EXECUTE Permission
Authenticating a Login Account for a Managed Resource
Related reference
Procedure Privilege Summary