-20072 csect-name bind-type bind-subtype ERROR USING authorization-id AUTHORITY. OPERATION IS NOT ALLOWED ON A package-type PACKAGE package-name

Explanation

The bind subcommand bind-type with bind-subtype is not valid for the type of package specified for one of the following reasons:

• The subcommand REBIND TRIGGER PACKAGE can be used only for trigger packages that were created prior to Db2 12 with new function activated, or basic triggers.
• The subcommand BIND PACKAGE DEPLOY can be used only for SQL functions or native SQL procedure packages, or for advanced triggers.
• The subcommand FREE PACKAGE can be used only for packages that are not associated with triggers, native SQL procedures, or compiled SQL functions.
• The DROP PACKAGE statement cannot be used to drop a REST SERVICE package. Use subcommand FREE SERVICE instead

csect-name

The name of the control section that issued the message.

bind-type

The type of bind subcommand: REBIND, FREE, or DROP.

bind-subtype

The subtype of bind subcommand: TRIGGER or DEPLOY.

authorization-id

The authorization ID that is attempting the prohibited action.

If you are using a trusted context, the token authorization-id might return a role instead of an authorization ID. A role is returned if a role was in effect and the authorization checking is performed against the role rather than the authorization ID of the session when the condition was encountered.

role-name

The name of the role, in the format: 'Role: role-name'

package-type

The type of package: trigger, SQL function, native SQL procedure, or REST SERVICE.

package-name

The name of the package, in the format 'collection.package'.