Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

SQLCODE -922

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> COBOL Programming
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    Post subject: SQLCODE -922
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    Post subject:
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    Post subject:
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    Post subject:
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

Site Director


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

PostPosted: Thu Dec 13, 2007 11:03 pm    Post subject:
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    Post subject:
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    IBMMAINFRAMES.com Support Forums -> COBOL Programming All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts SQLCODE-000000080N priya91 DB2 1 Mon Feb 01, 2016 4:35 pm
No new posts Need to understand SQLCODE = 12 rohanthengal DB2 3 Thu Nov 05, 2015 11:22 am
No new posts SQLCODE -922 in Batch-Cics program tr... kishpra CICS 2 Thu Sep 10, 2015 12:36 pm
No new posts SQLCODE -450 for stored procedure spoorni DB2 3 Fri Jan 16, 2015 2:45 am
No new posts -81 SQLCODE returned when Remote Stor... kameswaramanoj.Akella DB2 1 Wed Dec 03, 2014 5:36 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us