Bind Package panel

The Bind Package panel is the first of two DB2I panels that request information about how you want to bind a package.

You can reach the Bind Package panel either directly from the DB2I Primary Option Menu, or as a part of the program preparation process. If you enter the Bind Package panel from the Program Preparation panel, many of the Bind Package entries contain values from the Primary and Precompile panels. Figure 1 shows the Bind Package panel.

Figure 1. The Bind Package panel

DSNEBP07                  BIND PACKAGE                        SSID: DSN
 
 COMMAND ===>_
 
 Specify output location and collection names:
  1  LOCATION NAME ............. ===>                 (Defaults to local)
  2  COLLECTION-ID ............. ===>               > (Required)
 Specify package source (DBRM or COPY):
  3   DBRM:        COPY:         ===> DBRM      (Specify DBRM or COPY)
  4  MEMBER   or  COLLECTION-ID  ===>         >
  5  PASSWORD or  PACKAGE-ID ..  ===>         >
  6  LIBRARY  or  VERSION .....  ===>
                                                (Blank, or COPY version-id)
  7  ........ --  OPTIONS .....  ===>           (COMPOSITE or COMMAND)
 Enter options as desired:
  8  CHANGE CURRENT DEFAULTS?    ===> NO        (NO or YES)
  9  ENABLE/DISABLE CONNECTIONS? ===> NO        (NO or YES)
 10  OWNER OF PACKAGE (AUTHID).. ===>         > (Leave blank for primary ID)
 11  QUALIFIER ................  ===>         > (Leave blank for OWNER)
 12  ACTION ON PACKAGE ........  ===> REPLACE   (ADD or REPLACE)
 13  INCLUDE PATH? ............  ===> NO        (NO or YES)
 14  REPLACE VERSION ..........  ===>           (Replacement version-id)

The following information explains the functions on the Bind Package panel and how to fill the necessary fields in order to bind your program.

1 LOCATION NAME

Lets you specify the system at which to bind the package. You can use 1–16 characters to specify the location name. The location name must be defined in the catalog table SYSIBM.LOCATIONS. The default is the local DBMS.

2 COLLECTION-ID

Lets you specify the collection the package is in. You can use 1–128 characters to specify the collection, and the first character must be alphabetic. This field is scrollable.

3 DBRM: COPY:

Lets you specify whether you are creating a new package (DBRM) or making a copy of a package that already exists (COPY). Use:

DBRM: To create a new package. You must specify values in the LIBRARY, PASSWORD, and MEMBER fields.
COPY: To copy an existing package. You must specify values in the COLLECTION-ID and PACKAGE-ID fields. (The VERSION field is optional.)

4 MEMBER or COLLECTION-ID

MEMBER (for new packages): If you are creating a new package, this option lets you specify the DBRM to bind. You can specify a member name of 1–128 characters. This field is scrollable. The default name depends on the input data set name.

If the input data set is partitioned, the default name is the member name of the input data set specified in the INPUT DATA SET NAME field of the Db2 Program Preparation panel.
If the input data set is sequential, the default name is the second qualifier of this input data set.

COLLECTION-ID (for copying a package): If you are copying a package, this option specifies the collection ID that contains the original package. You can specify a collection ID of 1–128 characters, which must be different from the collection ID specified on the PACKAGE ID field. This field is scrollable.

5 PASSWORD or PACKAGE-ID

PASSWORD (for new packages): If you are creating a new package, this lets you enter password for the library you list in the LIBRARY field. You can use this field only if you reached the Bind Package panel directly from the Db2 Primary Option Menu. This field is scrollable.

PACKAGE-ID (for copying packages): If you are copying a package, this option lets you specify the name of the original package. You can enter a package ID of 1–128 characters. This field is scrollable.

6 LIBRARY or VERSION

LIBRARY (for new packages): If you are creating a new package, this lets you specify the names of the libraries that contain the DBRMs specified on the MEMBER field for the bind process. Libraries are searched in the order specified and must in the catalog tables.

VERSION (for copying packages): If you are copying a package, this option lets you specify the version of the original package. You can specify a version ID of 1–64 characters.

7 OPTIONS

Lets you specify which bind options Db2 uses when you issue BIND PACKAGE with the COPY option. Specify:

COMPOSITE (default) to cause Db2 to use any options you specify in the BIND PACKAGE command. For all other options, Db2 uses the options of the copied package.
COMMAND to cause Db2 to use the options you specify in the BIND PACKAGE command. For all other options, Db2 uses the following values:
- For a local copy of a package, Db2 uses the defaults for the local Db2 subsystem.
- For a remote copy of a package, Db2 uses the defaults for the server on which the package is bound.

8 CHANGE CURRENT DEFAULTS?

Lets you specify whether to change the current defaults for binding packages. If you enter YES in this field, you see the Defaults for Bind Package panel as your next step. You can enter your new preferences there; for instructions, see Defaults for Bind Package and Defaults for Rebind Package panels.

9 ENABLE/DISABLE CONNECTIONS?

Lets you specify whether you want to enable and disable system connections types to use with this package. This is valid only if the LOCATION NAME field names your local Db2 system.

Placing YES in this field displays a panel (shown in Figure 1) that lets you specify whether various system connections are valid for this application. You can specify connection names to further identify enabled connections within a connection type. A connection name is valid only when you also specify its corresponding connection type.

The default enables all connection types.

10 OWNER OF PACKAGE (AUTHID)

Lets you specify the primary authorization ID of the owner of the new package. That ID is the name owning the package, and the name associated with all accounting and trace records produced by the package.

The owner must have the privileges required to run SQL statements contained in the package.

The default is the primary authorization ID of the bind process.

The field is scrollable, and the maximum field length is 128.

11 QUALIFIER

Lets you specify the default schema for unqualified tables, views, indexes, and aliases. You can specify a schema name of 1–128 characters. The default is the authorization ID of the package owner. This field is scrollable.

12 ACTION ON PACKAGE

Lets you specify whether to replace an existing package or create a new one. Use:

REPLACE (default) to replace the package named in the PACKAGE-ID field if it already exists, and add it if it does not. (Use this option if you are changing the package because the SQL statements in the program changed. If only the SQL environment changes but not the SQL statements, you can use REBIND PACKAGE.)
ADD to add the package named in the PACKAGE-ID field, only if it does not already exist.

13 INCLUDE PATH?

Indicates whether you will supply a list of schema names that Db2 searches when it resolves unqualified distinct type, user-defined function, and stored procedure names in SQL statements. The default is NO. If you specify YES, Db2 displays a panel in which you specify the names of schemas for Db2 to search.

14 REPLACE VERSION

Lets you specify whether to replace a specific version of an existing package or create a new one. If the package and the version named in the PACKAGE-ID and VERSION fields already exist, you must specify REPLACE. You can specify a version ID of 1–64 characters. The default version ID is that specified in the VERSION field.