What is the syntax of SELECT statement when embedded in a COBOL program?

2 Answers  

---

Do we need cursor for Count(*)?

4 Answers   iGate,

---

What will the DB2 optimizer do?

2 Answers  

---

What are the 2 sqlcodes that are returned?

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  

---

---

What is the difference between db2 and oracle?

0 Answers  

---

If the main program has only cobol statements and subprogram has the db2 statements what is the procedure for precompilation. for which program we need to do the precompilation

1 Answers   IBM,

---

AGGREGATE function support by DB2. A) SUM & AVG B) SUM, MIN & AVG C) SUM, MAX, AVG , MIN &COUNT D) NONE

2 Answers   Accenture,

---

Can we insert update delete in view?

0 Answers  

---

How do you select a row using indexes in db2?

0 Answers  

---

What is a synonym ?

2 Answers  

---

What is db2 bind?

0 Answers  

---