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,

---

What is the connection string to connect to the DB2 Database ?

0 Answers   MCN Solutions,

---

What is the difference between drop table and delete table?

0 Answers  

---

A Table feild is declared as Decimal(7,2). I want to insert the decimal in to this column thru cobol-db2 program. How should I declare my local input file variable or any suggestion?

7 Answers   IBM,

---

how to u check the query is executing or not ?where will u check for sqlcode ?

6 Answers   Infosys,

---

we can code COPY DCLGEN or INCLUDE DCLGEN, At which stage of the precompilation , dclgen get expanded if we write 1) copy 2) include one question about dclgen.. Is it mandatory to use declare table in dclgen.. I think no...but it will be used by the precompiler to validate the table name,column name etc.., can one clear my doubt ..is it necessary to include declare table or not?

2 Answers  

---

how does the defining of a stored procedure effect the size of a DB2 data base A) it increases the size of a data base B) it decreases the size of a data base C) it does not effect the size of the data base D) it changes the table space structures

2 Answers   Accenture,

---

Can you search give an array in the WHERE clause of a db2 query?

1 Answers  

---

if any of the column names is provided wrong, where do you get the error(during precompilation or during Bind)

3 Answers  

---

What is a result table?

1 Answers  

---

Why do chiropractors use drop table?

0 Answers  

---

Where are plans stored?

2 Answers  

---