Procedures Editor (IBM DB2 Z/OS)

From RapidSQL
Jump to: navigation, search

Go Up to IBM DB2 for z/OS Object Editors

The Procedures Editor lets you manage the properties and input/output parameters of a procedure.

To edit a procedure

  1. Open an editor on the procedure. For details, see Opening an Object Editor.
  2. 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 Schema and Routine ID properties. Lets you set the External Name and Collection ID properties.

Run Time

Lets you set the Result Sets, WLM Environment, WLM For Nested, ASU Time, and Run Options properties.

Structure

Lets you view the Language, Number of LOB Columns, Number of Parameters, and DBINFO properties. Lets you set the Program Type, Security Type, SQL Access Level, Parameter Style, Inherit Special Registers, Fenced, Commit on Return, Deterministic, and Stay Resident 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

Displays a listing of the existing input/output parameters for the procedure. For the selected parameter, the Datatype list shows details for that parameter, including the Type and Parameter Mode (INPUT, OUTPUT, INPUT_OUTPUT). Depending on the type other parameters such as Size, Precision, or Scale may be available for viewing or modification. Optionally you can:

Select a parameter and in the Datatype list, modify details for that parameter.

Click the Add button to add a new parameter, provide a name for the new parameter, and edit the parameter values in the Datatype list.

Click the Delete button to drop a selected parameter.

Use the arrow buttons to change the order location of a selected parameter.

Comment

For details on using this tab, see Adding a Comment to an object.

Body

Lets you modify the SQL code for procedures on the current datasource

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.