Home > IT Answers > AS/400 > SQL Error -922
ankit2002
670 pts.
 SQL Error -922
AS/400
What is SQL Error -922 ?

Software/Hardware used:
AS400
ASKED: August 29, 2012  10:01 AM
RELATED QUESTIONS
 
  Help
 Approved Answer - Chosen by ankit2002 (Question Asker)

IMO, it doesn't make much sense to ask such a question in an interview. If you were to face an error like that while doing your work, you would not be expected to have all of the error codes in your memory to solve it.  That's why reference books and help pages exist.

ANSWERED:  Aug 29, 2012  3:00 PM (GMT)  by ankit2002
 
Other Answers:

You can check the SQL Codes errors on this page:

http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=%2Fcom.ibm.db2z10.doc.codes%2Fsrc%2Ftpc%2Fdb2z_n.htm

-922 it’s says:

AUTHORIZATION FAILURE: error-type ERROR.
REASON reason-code”

Last Wiki Answer Submitted:  August 29, 2012  10:50 am  by  ankit2002   670 pts.
Latest Answer Wiki Contributors:  ITTechPT   80 pts.
To see other answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

It’s not a familiar value. What is the OS version? What is the SQLSTATE? What messages were returned? What operation was being done? Where did you see the (-922)? — Tom

TomLiotta
 108,225 pts.
 

Now it needs to be clarified if this should be tagged “AS/400″ or if it actually is z/OS DB2. — Tom

TomLiotta
 108,225 pts.
 

@tom: I never saw this practically, this was the question asked in one of the interview.

ankit2002
 670 pts.
 

It especially doesn’t make sense if it was for an AS/400 position since it’s not a documented error value for AS/400s (through i 7.1 at least). — Tom

TomLiotta
 108,225 pts.