Answer / madhavansvce

update tablename set column name = value where condition.

What is catalog database in db2?

0 Answers  

---

What techniques will be used to avoid deadlock??

5 Answers   IBM, SUN,

---

How does the processing of a correlated subquery differ from a non correlated subquery?

1 Answers  

---

What is the purpose of using commit?

0 Answers  

---

What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

0 Answers   MCN Solutions,

---

---

If I have a view which is a join of two or more tables, can this view be updatable?

3 Answers  

---

When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

0 Answers   Broadridge,

---

I HAVE 2 TABLES ONE IS EMP_TABLE AND ANOTHER DEPT_TABLE.EMP_TABLE CONTAINS NAME,DEPTNO,DEPTNAME,LOCATION AND DEPT_TABLE CONTAINS DEPTNO,DOJ(DATE OF JOINING).I WANT TO DISPLAY NAME,DEPTNAME,DOJ AND WHO ARE JOINED BETWEN 01- JAN-2007 TO 01-JAN-2008?

6 Answers   Perot Systems,

---

What do you mean by between and in? Is between inclusive of specified range values?

0 Answers  

---

What is the meaning concurrency in the db2 database?

0 Answers  

---

OUTER JOINS USED TO GET MATCHING AND NONMATCHING ROWS FORM 2 OR MORE TABLES BASED ON COLUMNS. SIMPLE JOINS ALSO DO THE SAME THEN WHAT IS THE USE OF OUTER JOINS.

1 Answers   Syntel,

---

What is copy pending status in db2?

0 Answers  

---