how can u nderstand the sql stmts executed successfully or not ?

1 Answers   TCS,

---

Define data page.

0 Answers  

---

what is a plan and how do you refer the plan in the program?

2 Answers   Xansa,

---

what is the syntax for FOR UPDATE CLAUSE in cursor declaration and how can u update using cursor? is it possible to update multiple rows at a time.

2 Answers   Syntel,

---

Where can you declare a cursor in a cobol-db2 program?

0 Answers  

---

what is the soft code for deadlock ?

2 Answers   Logica CMG,

---

How to select the duplicate rows from a table?

4 Answers  

---

Consider that a package is bound into 2 different collections and the PKLIST option specifies both the collections. If the collection id is not specified in the program while executing the SQL query, then when the DB2 system will search the package list, which collection will it pick up or will it give an error/abend?

1 Answers  

---

What is tablespace?

3 Answers  

---

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,

---

What is a precompiler?

2 Answers  

---

What is IMAGECOPY ?

6 Answers  

---