Answer / abirami

select max(salary) from tablename
fetch first 10 rows only

is it compulsory commitment control in journal?

0 Answers   TCS,

---

What if we try to insert the base table through updatable view , but failed to give a column value which is defined as NOT NULL.

1 Answers   Cap Gemini,

---

I have some 3 particular fields ..i want to know which all tables have those 3 fields. Is there any way to identify.. can we know by quering system tables..

5 Answers   CTS,

---

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

0 Answers  

---

What is sqlcode -811?

7 Answers   Accenture, CTS, TCS,

---

how to fetch first 100 rows in db2

2 Answers   IBM,

---

How to update more then one record using update?

5 Answers   IBM,

---

What's the difference between DB2 active log and archive log? Thanks a lot...

2 Answers   IBM,

---

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

0 Answers  

---

Can we delete records from view?

0 Answers  

---

What is check constraint. Explain with example.

0 Answers  

---

What is filter factor?

2 Answers  

---