Answer Posted / guest

C) SUM, MAX, AVG , MIN &COUNT

How to view db2 table structure?

1016

---

what is the responsibility of the construction superintendent

2140

---

What is cursor with hold option in db2?

1069

---

Is the primary key a clustered index?

1146

---

What is db2 command?

1033

---

Explain about open switch business continuity software?

1128

---

Which component is responsible for processing sql statements and selecting access paths?

1127

---

What is the physical storage length of time data type?

1123

---

what is the sqlcode -501

13144

---

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 .....

2365

---

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

1127

---

What are catalog tables in db2?

1048

---

What is db2? Explain.

1041

---

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 ?

2324

---

What do you mean by commit and rollback?

1038

---