How to resolve -805 error in DB2?
Answer / lakshmi
Reason for Sql Code -805: The application program attempts
to use a DBRM package that is not found ('location-
name.colection-id.dbrm-name.consistency-token').
Solution:
1. Rebind the program with the correct DBRM library name.
2. The plan name used in the JCL and the plan used for bind
should be same.
Is This Answer Correct ? | 39 Yes | 3 No |
How to run db2 command in windows?
What is COPY PENDING status?
What is the difference between nvl and coalesce?
Is schema the same as database?
is it compulsory commitment control in journal?
If we keep the DCLGEN structure for a table in a copybook and include it in the COBOL program using the COPY statement, will there be any impact during compilation or at any stage of program execution?
I have a DB2 table which has 1000 rows.after udatingg first 110 rows, my job abends. Now what I have to do if I want to restart the job next time so that it should start updating from 111th row (without updating first 110 rows again).
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
What is collection in db2 bind?
What Utility is used to migrate DB2 from one release to the next?
Which DB2 catalog tables are used to produce a list of table column by table for all tables in a database?
how can u retrieve the data from null values using applicaion program.