Procedures Editor (IBM DB2 LUW)

From RapidSQL
Jump to: navigation, search

Go Up to IBM DB2 for Linux, Unix, and Windows Object Editors

The Procedures Editor lets you manage the body and parameters for 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 modify the following settings: SQL Access Level (MODIFIES SQL DATA, CONTAINS SQL, READS SQL DATA, NO SQL), number of Result Sets, External Action, New Save Point, Inherit Special Registers, Deterministic, and Parameter CCSID. Lets you view the following settings: Language (C, COBOL, JAVA, OLE, SQL CLR), External Name, Threadsafe, Fenced, Parameter Type (GENERAL, DB2, GENERAL WITH NULLS, SQL), Program Type (MAIN, SUB and not enabled for a Parameter Style of SQL), and DBInfo.

Parameters

Lets you manage procedure parameters. On opening, this tab shows the existing parameters. Optionally you can:

Select a parameter from the list, modify the Type, and if appropriate, the Precision, Size, and Scale of the parameter. You can also set the Parameter Mode to INPUT, OUTPUT, or INPUT_OUTPUT.

Click the New button, provide a name for the new parameter and modify its attributes.

Select a parameter and click the Drop button to delete the parameter.

Select a parameter and use the arrow buttons to reorder the parameter list.

NOTE: You cannot use host variables in the CALL statement for the name of the procedure.

Comment

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

Body

Lets you modify the body of the procedure.

Dependencies

For details on using this tab, see Working with Object Dependencies.

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.