how do you resolve -805?
Answers were Sorted based on User's Feedback
Answer / pratap
-805 DBRM OR PACKAGE NAME
location-name.collection-id.dbrm-name.consistency -token NOT
FOUND IN PLAN plan-name. REASON reason. Suggestion: Ensure
COLLECTION name is in DB2 PLAN. Recompile and BIND the DB2
program. Verify correct LOAD library is being used.
| Is This Answer Correct ? | 7 Yes | 1 No |
Answer / siri
-805 :- PLAN not found....
RESOLVE :- given the correct plan name....
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / vinay
The module needs to be binded. compile the module with
binding step in it.
| Is This Answer Correct ? | 1 Yes | 3 No |
What is cursor stability?
What is explain in db2?
How do you prepare a COBOL + DB2 program from coading till execution ?
what are extents?
Is it Possible to declare or create a cursor for UPDATE of table? If yes tell me how? If no Tell me why?
My DB2 program first read the data from a file and then it look into a table with the data it got from the file.If we did not bind the program , should the file read before SQL execution be success??
query to just fetch first matching row and stop execution. once one matching row is found ..no more records should be checked.. if the first record is matching.. the query must stop
Can you access the DB2 Directory table using SQL?
Mention the different locking levels that are available in db2.
What's the Maximum Length of SQLCA and what's the content of SQLCABC?
how to resolve -818 error. how to see timestamp token in load module and plan
Request to database but database is not available so what is was abend is raised?