If you are using SQL selects in your CICS prog, can you tell
me whether you get authorization failure -922, when invoking thru
Java. If not, can you tell which parameters are needed(mandatory)
in Java for successful execution of SQLs in CICS code.
Joined: 23 Nov 2006 Posts: 19270 Location: Inside the Matrix
When you have a new question, please start a new topic for your question.
The -922 is a security violation and you will need to talk with the DBA(s) and/or security admin people to have the necessary permissions granted to the usereid(s) that will be used by the java interface. When db2 "sees" the request, it validates the userid permissions, not the external interface (i.e. java).