Previous
Previous
 
Next
Next

Browsing a Function

To view a function in Object Browser:

  1. On the Workspace home page, click SQL Workshop and then Object Browser.

    Object Browser appears.

  2. From the Object list, select Functions.

  3. From the Object Selection pane, select a function.

    The Code view appears. You can edit the code in this view.

Summary of Available Views

Click the tabs at the top of the page to view different reports about the function. Table: Available Views for Functions describes all available views.

Available Views for Functions

View Description

Code

(Default) Displays the source code for the function. You can edit the code in this view. Actions you can perform in this view include:

  • Edit

  • Undo

  • Redo

  • Save & Compile

  • Download Source

  • Drop

  • Find & Replace

See Also: "Editing a Function", "Compiling a Function", "Downloading a Function", and "Dropping a Function"

Dependencies

Displays objects that use (or depend) on the current function and objects the function depends on.

Errors

Displays errors related to the current function.

Grants

Lists details of grants for the current function, including privilege, grantee, grantable, grantor, and object name.