Packages Editor (IBM DB2 Z/OS)

Go Up to IBM DB2 for z/OS Object Editors

The Packages Editor lets you manage properties and bind parameters for a package, as well as view environment information, package contents and associated plans.

To edit a package

1. Open an editor on the package. 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 the following properties: Average Size, Bind Time, Consistency Token, Dec31, Decimal Point, Group Member, Katakana Charset, Language, Mixed Character Set, Operative, Package Size, Package Source, PDS Name, Precompile Timestamp, Release Bound, String Delimiter, SysEntries, Timestamp, and Valid.
Bind Parameters	Lets you set the Schema Path, Creator, Qualifier, Explain, Validate, Degree, Dynamic Rules, Lock Isolation, Encoding, Page Writes, Resource Release, CurrentData, DB Protocol, Reoptvar, Keep Dynamic, Defer Prepare, SQL Error, and Optimization Hint properties.
Plan/Packlists	Displays the plans contained in the package if the package was bound individually, or as part of a complete collection ID. Optionally, you can:
		Select a plan and click Edit to open the Plans editor on the plan. For more information, see Plans Editor (IBM DB2 Z/OS).
		Select a plan and click Rebind to initiate rebinding the plan. For more information, see Rebind Plans.
		Select a plan and click Free to initiate deleting the plan. For more information, see Drop.
Statements	Shows the contents of any package statement on the datasource. Optionally, select a statement and click Explain to copy the statement to an ISQL Editor window. NOTE: For more information, see Using the SQL Editor.
Dependencies	For details on using this tab, see Working with Object Dependencies.
Privileges	For details on using this tab, see Working with Privileges and Permissions.
Environments	Displays run-time environments information for a package. Use the arrow buttons to move environments between the Enabled Environments and Disabled Environments lists. To modify a connection, select the environment and click Edit Connections. For more information, see Connection Editor.
Command	Displays the command that originally built the package.

3. When finished, you can submit your changes. For details, see Previewing and Submitting Object Editor Changes.

Connection Editor

The Connection Editor lets you modify plan and package connections. It is opened from the Packages editor. For more information, see Packages Editor (IBM DB2 Z/OS).

The table below describes the options and functionality of the Connection Editor:

Option	Description
Connections	Displays the connections for the plan or package.
Add	Click to add the connection.