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.

How can you count the number of rows from a table tab?

1 Answers  

---

What is dynamic SQL?

1 Answers   ADP,

---

What is -904 sql code? How to resolve it?

3 Answers  

---

What is view db2?

1 Answers  

---

What is a NULL value? What are the pros and cons of using NULLS?

2 Answers  

---

What is Reorg Recovery? when will you run it?

2 Answers  

---

WHAT IS NULL INDICATOR ? WERE IS THIS USED? AND IF IT IS USED IN FILES CONCEPT? HOW DO WE USE IT?

2 Answers   IBM,

---

What do you mean by NOT NULL? When will you use it?

3 Answers  

---

What is a synonym ?

2 Answers  

---

what is the sqlcode -501

6 Answers   IBM, Polaris, Zeus,

---

What is consistency token in db2?

1 Answers  

---

db2 maintains information about the data... a.in tables. b.in a set of tables known as db2 catalog. c.in db2 database. d.none of the above.

1 Answers  

---