Answer Posted / harish

dbrm or package is input to plan....talking abt
dbrm.......the cobol+db2 prgrm is input to precompiler which
separtes cobol souce code and dbrm

Define sqlca.

833

---

What is multi row fetch in db2?

751

---

Explain packages.

846

---

What is a trigger in the db2 database?

770

---

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?

2119

---

---

What is db2 catalog database?

772

---

If I have a view which is a join of two or more tables, can this view be updateable?

885

---

What is the difference between db2 and oracle?

852

---

What is a db2 collection?

782

---

Mention the definition of cobol in varchar field.

863

---

How and when does the db2 enforces the unique key?

823

---

How do you find the maximum value in a column in db2?

813

---

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2490

---

What is database reorganization?

802

---

i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?

2249

---