Answer Posted / sachin

db2 every coloumn have prefix .
if its hexa = '00' then coloumn have the null value
and if its other than null then it containx 'ff'

have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.

1660

---

Mention the location where the output received from explain statement is stored.

1054

---

What is cursor stability in db2?

1276

---

What is the syntax for FETCH in DB2 ?

1137

---

What is the difference between nvl and coalesce?

1009

---

How to resolve deadlock issue

19862

---

What is dclgen in db2?

1082

---

What is cursor in dbms?

1005

---

What is cobol db2?

933

---

what is the role of the cursor in db2?

999

---

What is deadlock in db2?

1016

---

What is image copy in db2?

943

---

What is the default page size of buffer pools?

1069

---

Why do we bind in db2?

1139

---

What language is db2 written in?

980

---