Functions Editor (IBM DB2 Z/OS)
Go Up to IBM DB2 for z/OS Object Editors
The Functions Editor lets you view and modify properties for a function, manage its inputs and outputs, and modify the code in the body of the function.
To edit a function
- Open an editor on the function. For details, see Opening an Object Editor.
- Use the following table as a guide to understanding and modifying the settings on the tabs of this editor:
Tab | Settings and tasks | |
---|---|---|
Properties |
Lets you work with properties in the following categories: | |
Identification |
Lets you view the Create Timestamp, Schema, Routine ID, and Origin properties. Lets you set the External Name and Collection ID properties. | |
Run Time |
Lets you view the Result Sets property. Lets you set the WLM Environment, WLM For Nested, ASU Time, and Run Options properties. | |
Structure |
Lets you view the Language, Parameter Style, Number of LOB Columns, Number of Parameters, and Allow Parallel properties. Lets you set the Program Type, Security Type, SQL Access Level, Inherit Special Registers, Fenced, DBINFO, Deterministic, Called On Null Input, External Action, Stay Resident, Final Call, Scratchpad, and Scratchpad Length properties. | |
Run Estimates |
Lets you view the Initial I/Os, I/Os Per Invocation, Initial Instructions, and Instructions Per Invocation properties. | |
Java Structure |
Lets you view the Java Class, Jar ID, Package ID, Method ID, Jar Schema, and Java Signature properties. | |
Parameters, Return Columns, and Return Scalar |
On opening, these tabs displays the current function parameters, return columns or return scalar. Optionally, take one of the following actions: | |
Select a parameter, return column, or return scalar in the Attributes area, modify values, as permissible. Attributes differ by the tab you chose but typically include items such as Type, Precision, Scale, As Locator, and Size. | ||
Click the New button to provide datatype and size details for a new parameter, return column, or return scalar. | ||
Select a parameter, return column, or return scalar and click Drop to delete that parameter. | ||
Body |
Lets you modify the code in the text area of the tab. | |
Comment |
For details on using this tab, see Adding a Comment to an object. | |
Permissions |
For details on using this tab, see Working with Privileges and Permissions. | |
DDL View |
For details on using this tab, see Viewing the SQL/DDL for an Object. |
- 3. When finished, you can submit your changes. For details, see Previewing and Submitting Object Editor Changes.