Answer / Ankita Rastogi

In DB2, a package is a collection of related procedures, functions, and types. It provides a means to encapsulate the code into a single unit for easier management, security, and reusability.

What is dbrm library?

1 Answers  

---

What are the 4 environments which can access DB2 ?

2 Answers  

---

What os does db2 run on?

1 Answers  

---

What is isolation level?

4 Answers  

---

What techniques will be used to avoid deadlock??

5 Answers   IBM, SUN,

---

what is contained in the DB2 node lock file? A) data base names B) data base users names C) license keys D) server names

5 Answers   Accenture,

---

difference between group clause and order clause

1 Answers  

---

what is diffrence b/w file-aid tool and file-aid utility???

2 Answers  

---

if any of the column names is provided wrong, where do you get the error(during precompilation or during Bind)

3 Answers  

---

Hi i need to write a query on the following requirement. SELECT COMM_TEXT INTO :WS_MIKM_COMM_TEXT FROM MPIPROD.MIKMV01 WHERE ACCOUNT_NO = :WFD_ACCOUNT_NO AND (SUBSTR(COMM_TEXT,1,39) = :WS_COMMENT_TEXT AND SUBSTR(COMM_TEXT,47,14) = :WS_DENY_DESC) OR (SUBSTR(COMM_TEXT,1,39) = :WS_COMMENT_TEXT) The above query is to be modified. The requirement is if both the fields are equal then that has to be given priority. In the above query if it satisfies any one it comes out without checking if both being equal is possible.

1 Answers  

---

For Read Stability locks are not applicable for phantoms, What is Phantoms?

2 Answers  

---

How do I copy a table in db2?

1 Answers  

---