Answer / satty

select country,sum(salesamt) from table1 groupby country;

but if its primary key is cust-no, then it will show error
-803 try to insert duplicates in primary key value.

Answer / raghu

select country,sum(salesamt) from table1 where country = ind;

This was related to -811 sqlcode, In a COBOL DB2 program which accesses employee table and selects rows for employee 'A', it should perform a paragraph s001-x if employee 'A' is present. In this case it gets -811 sqlcode, but still it process the paragraph s001-x. What could be wrong in my code.

4 Answers  

---

What is query_cache_limit?

1 Answers  

---

4. A DB2 application is bound with uncommitted Read isolation level.It issues a request that retrieves 20 rows out of 200000 in the table. Which of the following descrbes the rows that are locked as a result of this request? a. None of the rows are locked. B.The retrieved rows are locked. C.The last row of the result set is locked. D.The rows not previously updated by another application are locked.

3 Answers   Wipro,

---

DB2 is a A) data base/data communication system B) data base C) RDBMS D) Programming language

4 Answers   Accenture,

---

Is there any advantage to denormalizing DB2 tables?

1 Answers  

---

insert into tablename a column1, column2 select column1, column2 from tablename b i am getting abend -104..can any one help?

3 Answers   Syntel,

---

What are the three lock types?

2 Answers  

---

When Can you be sure that a query will return only one row?

4 Answers   IBM,

---

When is the skeleton cursor table created?

1 Answers  

---

Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

1 Answers  

---

what is the process of precompiler?

2 Answers  

---

How could one combine a set of incremental image copies into a single copy?

1 Answers  

---