IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

SQLCODE -922


IBM Mainframe Forums -> COBOL Programming
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
ousep143

New User


Joined: 06 Oct 2007
Posts: 32
Location: India

PostPosted: Thu Dec 13, 2007 1:12 pm
Reply with quote

Hi

How to solve SQLCODE -922?In compilation time,no error is occurred.


Regards
icon_smile.gif
Back to top
View user's profile Send private message
ameenansari

New User


Joined: 18 Sep 2006
Posts: 11
Location: chennai

PostPosted: Thu Dec 13, 2007 1:41 pm
Reply with quote

-922 is authorization error.

Owner id is in your plan control does not have access to compile your program
Back to top
View user's profile Send private message
ousep143

New User


Joined: 06 Oct 2007
Posts: 32
Location: India

PostPosted: Thu Dec 13, 2007 2:31 pm
Reply with quote

Hi
Thanks for reply.I already told that this error occurred at runtime, not compile time.How to solve this problem.


Regards
icon_smile.gif
Back to top
View user's profile Send private message
chtrisa

New User


Joined: 19 Dec 2006
Posts: 12
Location: chennai

PostPosted: Thu Dec 13, 2007 3:41 pm
Reply with quote

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
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Thu Dec 13, 2007 11:03 pm
Reply with quote

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

New User


Joined: 06 Oct 2007
Posts: 32
Location: India

PostPosted: Tue Dec 18, 2007 10:55 am
Reply with quote

Hi

Thanks for reply.


Regards
icon_smile.gif
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> COBOL Programming

 


Similar Topics
Topic Forum Replies
No new posts SQLCODE = -122 while using the scalar... DB2 4
No new posts SQLCODE = -16002 when using XMLEXISTS DB2 1
No new posts Is SQLCODE -811 possible while fetchi... DB2 1
No new posts SQLCODE=-204 SQLSTATE=42704 DB2 4
No new posts Getting sqlcode 805 while executing R... DB2 10
Search our Forums:

Back to Top