PACKAGE bind options

Descriptions for BIND PACKAGE

The following options identify the package to bind. You can identify the location and collection ID. The DBRM supplies the package ID and version ID if you use the MEMBER option. See MEMBER bind option. Otherwise, these IDs come from the COPY option. See COPY bind option

PACKAGE(location-name)

The location of the DBMS where the package binds and where the description of the package resides. The location name must be defined in catalog table SYSIBM.LOCATIONS. If that table does not exist or if the DBMS is not in it, you receive an error message. See LOCATIONS catalog table.

The default is the local DBMS.

PACKAGE(collection-id)

Specifies the collection to contain the package to bind. There is no default value.

collection-id can be an undelimited or delimited identifier. The delimiter for collection-id is double quotation marks ("). If collection-id is delimited, Db2 does not convert the value to uppercase.

Other options for BIND PACKAGE

For descriptions of the other options in the syntax diagram, see BIND and REBIND options for packages, plans, and services.

Descriptions for REBIND PACKAGE

The following options identify the packages to rebind by specifying the location, collection, package name, and version. You must identify a package name, and you can also supply a version ID.

location-name

The location of the DBMS where the package rebinds and where the description of the package resides. The location name must be defined in the SYSIBM.LOCATIONS catalog table. If that table does not exist or if the DBMS is not in it, you receive an error message. See LOCATIONS catalog table.

The default is the local DBMS.

collection-id or *

Specifies the collection to contain the package to bind, or that already contains the package to rebind. There is no default.

You can use an asterisk (*) to rebind all local packages with the specified package-id in all the collections for which you have bind privileges.

package-id or *

Specifies the name of the package to rebind, as listed in column NAME of catalog table SYSPACKAGE. There is no default. You can use an asterisk (*) to rebind all local packages in collection-id for which you have bind privileges.

The package-id value can be an undelimited or delimited identifier. The delimiter for package-id is double quotation marks ("). If package-id is delimited, Db2 does not convert the value to uppercase.

version-id or *

Specifies the version of the package to rebind, as listed in column VERSION of catalog table SYSPACKAGE.

You can use an asterisk (*) to rebind all local versions of the specified package-id in collection-id for which you have bind privileges.

Using only () rebinds the version of the package that is identified by the empty string.

If you omit version-id , the default depends on the how you specify package-id . If you use * for package-id , then version-id defaults to *. If you explicitly provide a value for package-id , then version-id defaults to the empty string version.

*

Rebinds all local Db2 packages for which the applicable authorization ID has the BIND privilege. Specifying (*) is the same as specifying the package name as (*.*.(*)) or (*.*). The applicable authorization ID is:

• The value of OWNER, if you use that option
• The primary authorization ID of the process running the bind, if you do not use the option OWNER

Other options for REBIND PACKAGE

For descriptions of the other options in the syntax diagram, see the topic BIND and REBIND options for packages, plans, and services.

Catalog records for PACKAGE

See the COLLID, NAME, and VERSION columns in SYSPACKAGE catalog table.