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 |
If there is no row in Emp table with Ename as Raghava and you run the below queries in SPUFI. 1.select Ename from EMP wher Ename = 'raghava' 2.Select count(*) from EMP where Ename = 'raghava' What is SQLCODE shown up in SPUFI
How do you insert a record with a nullable column?
what is db2 restart?
what are stage one indexable predicates?
What is ACQUIRE/RELEASE in BIND?
when we are tying to update a table having 100 rows. if the program abends when updating 51 row . how to start updating again from the 51 row .what was the logic
How can you compare table column after update and before update?
How is a typical db2 batch pgm executed?
Explain the benefits you can get from mainframe connect?
How to resolve -502 sql code in DB2?
What is db2 command?
The only place of VSAM KSDS in DB2 is?