What does sqlcabc has?

0 Answers  

---

what is different three logs in DB2?

1 Answers   Syntel,

---

select * from orders where odate between '2010-01-01'and '2010-03-31' How do u fetch this into cursor?

2 Answers  

---

suppose in my table 10 rows are there , i want to update odd rows salary as 90000 ? how u do it ? any one help me ? what do we use here cursor-fetch or normal sql ?

5 Answers   IBM,

---

What is the reason behind not using select * in embedded sql programs?

0 Answers  

---

When the like statement is used?

0 Answers  

---

What is explain plan in db2?

0 Answers  

---

What is db2 instance?

0 Answers  

---

What is the difference between IN subselects and EXISTS subselect?

1 Answers   HCL, PreVator, TCS,

---

How can you find out which query is taking lot of time to execute in cobol-db2 program ?

1 Answers   Danske,

---

What do you mean by cursor?

0 Answers  

---

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,

---