| IBM MAINFRAME HELP FORUMS for COBOL, JCL, CICS, DB2, IMS etc...
Help & Support Forums for IBM Mainframe computers Applications like COBOL, JCL, CICS, DB2, FileAid, DFSORT, Endevor, Xpediter, CoolGen, CA-7, CA-11, AbendAid, IMS, IDMS, PL/I, MqSeries, SyncSort, Assembler, VSAM, ISPF, ChangeMan, Easytrieve, InterTest, REXX, CLIST etc...
|
| View previous topic :: View next topic |
| Author |
Message |
ousep143
Joined: 06 Oct 2007
Posts: 32
Location: India
|
| Posted: Thu Jun 05, 2008 4:58 pm Post subject: SQLCODE -904 while opening a cursor |
|
|
I was getting SQLCODE = -904 while opening a cursor,
Please tell me what to do? |
|
| Back to top |
|
Gnanas SNG
Joined: 06 Sep 2007
Posts: 416
Location: India
|
| Posted: Thu Jun 05, 2008 5:07 pm Post subject: |
|
|
-904 UNSUCCESSFUL EXECUTION CAUSED BY AN UNAVAILABLE RESOURCE. REASON
reason-code, TYPE OF RESOURCE resource-type, AND RESOURCE NAME
resource-name
Explanation: The SQL statement could not be executed because resource
resource-name of type resource-type was not available at the time for the
reason indicated by reason-code. Refer to Table 3 in Appendix B, "Problem
determination" in item -PROBLEM_DETERMI for an explanation of resource type
codes. Refer to "DB2 codes" in item -DB2_CODES for an explanation of the given
reason code.
If this is issued in connection with Multilevel Security authorization
(resource-type 402), then the Security Server return and reason codes for
the unavailable resource appear as the resource-name. In this case, refer
to the z/OS Security Server RACROUTE Macro Reference.
System Action: The SQL statement cannot be executed. If the SQL statement
being executed was a cursor FETCH, DB2 closes the cursor. Subsequent
attempts to use that cursor without first doing an OPEN for it receive an
SQLCODE -501.
Programmer Response: Verify the identity of the resource that was not
available. To determine why the resource was unavailable, refer to the
specified reason-code.
SQLSTATE: 57011 |
|
| Back to top |
|
enrico-sorichetti
Joined: 14 Mar 2007
Posts: 2535
Location: italy
|
| Posted: Thu Jun 05, 2008 5:08 pm Post subject: Reply to: SQLCODE -904 while opening a cursor |
|
|
-904 is an unavailable resource SQLCODE
You' ll have to post all the messages or look them up Yourself in the manual in order to find out what to do |
|
| Back to top |
|
ousep143
Joined: 06 Oct 2007
Posts: 32
Location: India
|
| Posted: Thu Jun 05, 2008 8:33 pm Post subject: Re: Reply to: SQLCODE -904 while opening a cursor |
|
|
| Thanx Enrico & Gnanas |
|
| Back to top |
|
balaji.ghanta
Joined: 26 Jun 2008
Posts: 2
Location: Bangalore
|
| Posted: Mon Jul 07, 2008 4:02 pm Post subject: |
|
|
-904 is for resource not available. Varify the below
1) Please check whether the table is existing or not.
2) Might be your utilitilib is not be existing. So, in this case check with your corresponding DBA. He will solve your problem. |
|
| Back to top |
|
| |
THIS IS AN ARCIVE FORUM IN READ ONLY MODE. IF YOU WANT TO ASK YOUR DOUBTS USE THE ACTUAL FORUM
|