|
View previous topic :: View next topic
|
| Author |
Message |
karthikuma
New User
Joined: 29 Mar 2005
Posts: 62
|
|
|
|
Hi,
this i've been faced in the interview.
the interviewer asked me what is -805.i said that it's program name is not found in plan.he told that progarm name is correct but still i'm facing the same problem,wat's the reason usually u'll get this type of sqlcode.please any one give me an good solution ,even the progarm name is correct but i'm geting -805.what's the problem.give me an good solution. |
|
| Back to top |
|
 |
priyesh.agrawal
Senior Member
Joined: 28 Mar 2005
Posts: 1448
Location: Chicago, IL
|
|
|
|
Hi karthikuma,
I Cant give you a clear picture....As I didnt have any exp on that.....Just got some material on that ...
Check whether it helps you.....
Explaination :
An attempt was made to execute the application program 'location name.collection id.program name.consistency token' (this token can be 'location name..program name.consistency token' if the current package set special register is blank for the local program execution) that has not been found due to one or more or the following reasons:
*The program 'program name' has not been bound as the member part of the application plan 'plan name'
*The 'collection id' in the PKLIST was not correct when the application plan 'plan name' was bound
*The current package set special register was not set correctly
*The 'location name' in the CURRENTSERVER was not correct when the application plan 'plan name' was bound,
*The application was not connected to the proper location
*The location id in the package list was not correct when the application 'plan name' was bound
*The DBRM of the version of the application program being executed was not bound.
Resolution :
Based on the above reasons, the programmer can perform the following operations to correct the error.
* Bind the program 'program name' as the member part of the application plan 'plan name'
* Correct the collection id in the PKLIST and bind the application plan 'plan name'
* Set the current package set special register correctly
* Put the correct 'location name' in the CURRENTSERVER of the BIND command and bind the application plan 'plan name'
* Connect to the correct RDB name
* Correct the location id in the PKLIST and bind the application plan 'plan name'
* Bind the DBRM of the version of the application program to be executed
Regards,
Priyesh. |
|
| Back to top |
|
|
|
|
