View previous topic :: View next topic
|
Author |
Message |
ousep143
New User
Joined: 06 Oct 2007 Posts: 32 Location: India
|
|
|
|
Hi
How to solve SQLCODE -922?In compilation time,no error is occurred.
Regards
|
|
Back to top |
|
|
ameenansari
New User
Joined: 18 Sep 2006 Posts: 11 Location: chennai
|
|
|
|
-922 is authorization error.
Owner id is in your plan control does not have access to compile your program |
|
Back to top |
|
|
ousep143
New User
Joined: 06 Oct 2007 Posts: 32 Location: India
|
|
|
|
Hi
Thanks for reply.I already told that this error occurred at runtime, not compile time.How to solve this problem.
Regards
|
|
Back to top |
|
|
chtrisa
New User
Joined: 19 Dec 2006 Posts: 12 Location: chennai
|
|
|
|
Hi,
-922,AUTHORIZATION FAILURE: error-type ERROR
Explanation: Authorization failed because of the error indicated by 'error-type', which may be one of the following:
1.User authorization
2.Plan access
3.Duplicate exit requested
4.Installation error.
System Action: The statement cannot be executed. The connection to DB2 is not established.
Programmer Response: If 'error-type' is 'user authorization', the authorization-ID specified to DB2 through your attachment facility is not valid for DB2. See your system programmer or your CICS, IMS, or TSO system administrator.
If 'error-type' is 'plan access', allocation of a requested plan is not allowed. See your system administrator.
If 'error-type' is 'duplicate exit', then you requested a duplicate exit.
If 'error-type' is 'installation-error', a logon validation exit has denied your request. See your system programmer.
Any attempts to issue SQL statements following the -922 return code will cause unpredictable results. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Quote: |
Thanks for reply.I already told that this error occurred at runtime, not compile time.How to solve this problem. |
You did not try to access anything that was restricted in the compile. . . .
You need to talk with youjr DBAs or security admin people and be granted permission(s) to do what the code is trying to do. |
|
Back to top |
|
|
ousep143
New User
Joined: 06 Oct 2007 Posts: 32 Location: India
|
|
|
|
Hi
Thanks for reply.
Regards
|
|
Back to top |
|
|
|