Answer / s

Skeleton cursor table is created when a new plan is bound.

Suppose if I need to update a column, how you do that using cursor?

2 Answers   Verizon,

---

Explain how can you do the explain of a dynamic sql statement?

0 Answers  

---

What is the maximum length of a column name in DB2? 18 or 30 or anything other than these?

4 Answers  

---

What is a clustering index ?

3 Answers  

---

which is the most efficient tablespace?? a.simple tablespace. b.partitioned tablespace. c.segmented tablespace. d.none of the above. please post answer with the reason.?

3 Answers  

---

What is the difference between plan and package in db2?

0 Answers  

---

In SPUFI suppose you want to select maximum of 1000 rows, but the select returns only 200 rows. What are the 2 SQLCODEs that are returned?

1 Answers  

---

in the CURSOR declare statement, if i am using an where clause and trying to compare the value with a host-varialble. EXEC SQL DECLARE C1 CURSOR FOR SELECT DEPTNO, DEPTNAME, MGRNO FROM DEPARTMENT WHERE ADMRDEPT = :ADM-DEPT Where would i need to provide value to this host-variable in the where clause. how could i pass value to this host-variable to check it.

2 Answers   iGate,

---

What does an outer join do?

1 Answers   CTS,

---

What is an access path?

3 Answers  

---

What is usage pointer in cobol?

3 Answers   IBM,

---

What is the syntax for seeing the columns and data types of a table in the db2 database?

0 Answers  

---