can we drop column from a table

7 Answers   INDUS,

---

Explain db2.

0 Answers  

---

How to design maps

1 Answers   Virtusa,

---

Can you use a select query in a loop to fetch multiple rows? If so what is the advantage of using a cursor?

2 Answers   L&T, UST,

---

For update of a row in cursors, when do we move value into host variable in cobol progrm? is it before open or before fetch ?

2 Answers   iGate,

---

---

Explain the EXPLAIN statement?

1 Answers  

---

what types of copies can be made with the COPY Utility ?

1 Answers  

---

if any of the column names is provided wrong, where do you get the error(during precompilation or during Bind)

3 Answers  

---

What is a db2 collection?

0 Answers  

---

Highlight all the advantages that are attached to a package.

0 Answers  

---

what is parm utility

2 Answers   IBM,

---

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,

---