What are foreign keys in db2?

0 Answers  

---

i want to know how the commit option works,how it save the changes? it will update the database or what ? where we can see these saved changes?

4 Answers  

---

What is the maximum length of sqlca?

0 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,

---

what is differnece between DROP TABLE & DELETE TABLE .

4 Answers   Cap Gemini,

---

Mention the different locking levels that are available in db2.

0 Answers  

---

how many partitions are possible in partitioned tablespace? dont say 1-64. a)240 b)256 c)512 d)none

8 Answers   Amdocs, HeadStrong,

---

Can we use select * statement in cobol program without giving field names ???

3 Answers   Zensar,

---

What is null in db2?

0 Answers  

---

what is the maximum number of tables that can be joined ?

8 Answers   IBM, TCS,

---

Normalization in DB2 – first normal form, second normal form

4 Answers   Virtusa,

---

What is a DB2 catalog?

2 Answers  

---