View previous topic :: View next topic |
Author |
Message |
jim haire Beginner
Joined: 30 Dec 2002 Posts: 140 Topics: 40
|
Posted: Mon Nov 30, 2015 10:58 am Post subject: -812 error encountered |
|
|
I don't remember ever seeing this error in the past. I am compiling a program that is read-only against DB2 and binding it to a read-only plan in production. (Our shop allows us to do this.). I am getting this issue, but the package list does not have an asterisk as the value in the collection ID.
-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.
|
|
Back to top |
|
|
kolusu Site Admin
Joined: 26 Nov 2002 Posts: 12360 Topics: 75 Location: San Jose
|
Posted: Mon Nov 30, 2015 11:30 am Post subject: |
|
|
jim haire,
Are you seeing this error recently ? Did this approach work for you earlier? For a temporary work around I would code this in your program and see if that works
Code: |
SET CURRENT PACKAGESET = 'your-prod-package-list' |
_________________ Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
www.linkedin.com/in/kolusu |
|
Back to top |
|
|
jim haire Beginner
Joined: 30 Dec 2002 Posts: 140 Topics: 40
|
Posted: Mon Nov 30, 2015 12:27 pm Post subject: |
|
|
This did seem to get around the issue, although I am now getting a -805 which should be easier to resolve.
Still not sure why I would get a -812. Does this bind syntax provide any clues?
DEVCL229 is the collection, RRSR110 is the package.
DSNT255I -DT1A DSNTBCM2 BIND OPTIONS FOR
PACKAGE = DB21A.DEVCL229.RRSR110.()
SQLERROR NOPACKAGE
CURRENTDATA NO
DEGREE 1
DYNAMICRULES
DEFER
NOREOPT VARS
KEEPDYNAMIC NO
IMMEDWRITE INHERITFROMPLAN
DBPROTOCOL DRDA
OPTHINT
ENCODING EBCDIC(00037)
PLANMGMT OFF
PLANMGMTSCOPE STATIC
CONCURRENTACCESSRESOLUTION
EXTENDEDINDICATOR
PATH |
|
Back to top |
|
|
kolusu Site Admin
Joined: 26 Nov 2002 Posts: 12360 Topics: 75 Location: San Jose
|
Posted: Mon Nov 30, 2015 3:09 pm Post subject: |
|
|
jim haire,
I am guessing there is a difference/upgrade between the 2 environments and something must have been clobbered up that the bind does not get a valid package name. So check if there are any upgrades done. _________________ Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
www.linkedin.com/in/kolusu |
|
Back to top |
|
|
|
|