MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

-812 error encountered

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Database
View previous topic :: View next topic  
Author Message
jim haire
Beginner


Joined: 30 Dec 2002
Posts: 140
Topics: 40

PostPosted: Mon Nov 30, 2015 10:58 am    Post subject: -812 error encountered Reply with quote

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
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12358
Topics: 75
Location: San Jose

PostPosted: Mon Nov 30, 2015 11:30 am    Post subject: Reply with quote

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
View user's profile Send private message Send e-mail Visit poster's website
jim haire
Beginner


Joined: 30 Dec 2002
Posts: 140
Topics: 40

PostPosted: Mon Nov 30, 2015 12:27 pm    Post subject: Reply with quote

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
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12358
Topics: 75
Location: San Jose

PostPosted: Mon Nov 30, 2015 3:09 pm    Post subject: Reply with quote

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
View user's profile Send private message Send e-mail Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Database All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group