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 required.

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

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

Modify SQL code for Watcom-SQL or Transcat-SQL procedures – Requires 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 –
  • Requires CREATE EXTERNAL REFERENCE system privilege.
  • Also requires one of:
    • ALTER ANY PROCEDURE system privilege.
    • ALTER ANY OBJECT system privilege.
    • You own the procedure.
Modify a comment for any procedure 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 procedure.
Modify permissions for any procedure 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 > 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 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 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. Click OK.
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