Answer Posted / nickyhuang

(B)users names

What is database manager in db2?

980

---

List out the data types available.

1105

---

What are concurrency issues?

1049

---

Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....

2327

---

Explain how can you do the explain of a dynamic sql statement?

1082

---

While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

2300

---

What are bind parameters in db2?

995

---

What is the information associated with sysibm.syslinks table?

1083

---

What does db2 stand for?

969

---

Is schema the same as database?

1018

---

by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

9059

---

How many types of page locks can be held in db2?

1005

---

Why cursor is used in db2?

1003

---

What is db2 bind?

1029

---

What is dbrm? What it contains?

1125

---