-812 THE SQL STATEMENT CANNOT BE PROCESSED BECAUSE A BLANK COLLECTION-ID WAS FOUND IN THE CURRENT PACKAGESET SPECIAL REGISTER WHILE TRYING TO FORM A QUALIFIED PACKAGE NAME FOR PROGRAM `program-name.consistency-token` USING PLAN `plan-name`

Explanation
The last entry or the only entry in the package list for the plan contained an asterisk (*) as
the value of the collection ID. The CURRENT PACKAGESET special register must be set to a nonblank
collection ID to form a qualified package name.

System action
The statement cannot be processed.

Programmer response
Set the CURRENT PACKAGESET special register to the correct collection ID, or ask your system
administrator to check the plan's package list for correctness.

If this error occurs in an application that is running under the IBM® Data Server Driver for JDBC and
SQLJ, you might have too many concurrently open
Statement, PreparedStatement, or
CallableStatement objects. Modify your application to decrease the number of
concurrently open objects, or run the DB2Binder utility again with a larger -size parameter value to
increase the number of packages that are available to the driver.

SQLSTATE
22508

-812 THE SQL STATEMENT CANNOT BE PROCESSED BECAUSE A BLANK COLLECTION-ID WAS FOUND IN THE CURRENT PACKAGESET SPECIAL REGISTER WHILE TRYING TO FORM A QUALIFIED PACKAGE NAME FOR PROGRAM program-name.consistency-token USING PLAN plan-name

Explanation

System action

Programmer response

SQLSTATE

-812 THE SQL STATEMENT CANNOT BE PROCESSED BECAUSE A BLANK COLLECTION-ID WAS FOUND IN THE CURRENT PACKAGESET SPECIAL REGISTER WHILE TRYING TO FORM A QUALIFIED PACKAGE NAME FOR PROGRAM `program-name.consistency-token` USING PLAN `plan-name`