Editing an ASE User-Defined Function

After creating a user-defined function, use the editor to modify parameters, permissions, or other properties.

Prerequisites 

Be sure the data server that contains the user-defined function is running, and that you have created and established a connection to the data server.

  1. In the Databases folder in Enterprise Explorer, under the database connection profile, expand the Databases folder, expand the tree for a database, and then expand the tree for the appropriate schema owner.
  2. Expand the User Defined Functions folder, right-click the user-defined function you want to edit, and select Edit.
  3. Edit the user-defined function properties.
    Editor tab Description
    General
    • Change the Name. Enter a description in the Comment field.
    • Specify Parameters and their corresponding datatypes, input or output status, and defaults. To delete a parameter, highlight it and click Delete. To delete all parameters, click Delete All. Use Up and Down to change the order of parameters listed.
    • Select a Return Type.
    • Select With Recompile, if appropriate. If selected, the stored procedure is recompiled to create a new plan each time the function is first referenced in a SQL statement.
    Source Manually edit the SQL code. To display line numbers for the SQL code, right-click in the left margin, and choose Show Line Numbers.
    Permissions Set permissions for the user-defined function. You can specify Granted With Grant Option or Inherited permissions for the listed roles.
    DDL View the DDL for the user-defined function (read-only).
  4. Select File > Save from the main menu, or Ctrl+S.
Parent topic: ASE User-Defined Functions

Send your feedback on this help topic to Sybase Technical Publications: pubs@sybase.com

Your comments will be sent to the technical publications staff at Sybase, Inc. For product-related issues or technical support, contact Sybase Technical Support at 1-800-8SYBASE.