What is difference between *omit and *nopass?

1 Answers   IBM, TCS,

---

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,

---

How do we specify index to include or not during bind process.

0 Answers   Satyam,

---

What is image copy in db2?

0 Answers  

---

what is commit & rollback? When and where is used while compiling a cobol-db2 program?

2 Answers  

---

I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?

3 Answers  

---

Can I use LOCK TABLE on a view?

1 Answers  

---

What is the function of the Data Manager?

2 Answers  

---

What does CURRENTDATA option in bind indicate

1 Answers   IBM,

---

what are extents?

5 Answers  

---

I have a table name Table1 which contain columns Cust_no, car_model, country, salesamt. The records are 101, Fiat, India, 12345 2nd record is 102, Tata, USA, 98743 3rd record is 101, indica, India, 65342 4th record is 103, Toyota, UK, 64522 5th record is 103, Maruti, USA, 98632 and so on..... Now my question is write sql query which will give me detail about the sum of sales amount in perticular country

2 Answers   IBM,

---

Cursors can be declared in both working-storage & procedure division, Agreed. But is there any difference? If could you please suggest what is the difference. TIA

8 Answers   CGI, Wipro,

---