Rebind Package panel
The Rebind Package panel is the first of two panels that you use to rebind a package. This panel lets you specify options for rebinding the package.
The following figure shows the rebind package options.
DSNEBP08 REBIND PACKAGE SSID: DSN
COMMAND ===>_
1 Rebind all local packages ===> (* to rebind all packages)
or
Enter package name(s) to be rebound:
2 LOCATION NAME ............. ===> (Defaults to local)
3 COLLECTION-ID ............. ===> > (Required)
4 PACKAGE-ID ................ ===> > (Required)
5 VERSION-ID ................ ===>
(*, Blank, (), or version-id)
6 ADDITIONAL PACKAGES? ...... ===> (Yes to include more packages)
Enter options as desired ...... ===>
7 CHANGE CURRENT DEFAULTS?... ===> (NO or YES)
8 OWNER OF PACKAGE (AUTHID).. ===> > (SAME, new OWNER)
9 QUALIFIER ................. ===> > (SAME, new QUALIFIER)
10 ENABLE/DISABLE CONNECTIONS? ===> (NO or YES)
11 INCLUDE PATH? ............. ===> (SAME, DEFAULT, or YES)This panel lets you choose options for rebinding a package.
- 1 Rebind all local packages
- Lets you rebind all packages on the local DBMS. To do so, place an asterisk (*) in this field; otherwise, leave it blank.
- 2 LOCATION NAME
- Lets you specify where to bind the package. If you specify a location name, you should use 1–16 characters, and you must have defined it in the catalog table SYSIBM.LOCATIONS.
- 3 COLLECTION-ID
- Lets you specify the collection of the package to rebind. You must specify a collection ID from 1 to 128 characters, or an asterisk (*) to rebind all collections in the local Db2 system. You cannot use the asterisk to rebind a remote collection. This field is scrollable.
- 4 PACKAGE-ID
- Lets you specify the name of the package to rebind. You must specify
a package ID of 1–8 characters, or an asterisk (*) to rebind
all packages in the specified collections in the local Db2 system. You cannot use the asterisk to rebind
a remote package.
The field is scrollable, and the maximum field length is 128.
- 5 VERSION-ID
- Lets you specify the version of the package to rebind. You must specify a version ID of 1–64 characters, or an asterisk (*) to rebind all versions in the specified collections and packages in the local Db2 system. You cannot use the asterisk to rebind a remote version.
- 6 ADDITIONAL PACKAGES?
- Lets you indicate whether to name more packages to rebind. Use YES to specify more packages on an additional panel, described on Panels for entering lists of values. The default is NO.
- 7 CHANGE CURRENT DEFAULTS?
- Lets you indicate whether to change the binding defaults. Use:
- NO (default) to retain the binding defaults of the previous package.
- YES to change the binding defaults from the previous package. For information about the defaults for binding packages, see Defaults for Bind Package and Defaults for Rebind Package panels.
- 8 OWNER OF PACKAGE (AUTHID)
- Lets you change the authorization ID for the package owner. The
owner must have the required privileges to execute the SQL statements
in the package. The default is the existing package owner.
The field is scrollable, and the maximum field length is 128.
- 9 QUALIFIER
- Lets you specify the default schema for all unqualified
table names, views, indexes, and aliases in the package. You can specify
a schema name of 1–8 characters, which must conform to the rules
for the SQL short identifier. The default is the existing qualifier
name.
The field is scrollable, and the maximum field length is 128.
- 10 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.
The default is the values used for the previous package.
- 11 INCLUDE PATH?
- Indicates which one of the following actions you want to perform:
- Request that Db2 uses the same schema names as when the package was bound for resolving unqualified distinct type, user-defined function, and stored procedure names in SQL statements. Choose SAME to perform this action. This is the default.
- 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. Choose YES to perform this action.
- Request that Db2 resets the SQL path to SYSIBM, SYSFUN, SYSPROC, and the package owner. Choose DEFAULT to perform this action.