Can a primary key have null values? If we try to insert a null value in a primary key column, will it work or give an error code?

6 Answers  

---

What does the CHECK Utility do ?

1 Answers  

---

What is the maximum length of a column name in DB2? 18 or 30 or anything other than these?

4 Answers  

---

What are the different methods of accessing db2 from tso? How is the connection established between TSO & DB2?

3 Answers   Tech Mahindra,

---

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,

---

---

which SQL comment successfully removes uncommitted changes from a DB2 database A) rollback B) delete C) drop D) decommit

2 Answers   Accenture, Wipro,

---

wht steps we need will coding cobol and db2 pgm ?

6 Answers   CGI,

---

how to take the back up of the DB2 table.

7 Answers  

---

i want to delete 20th million record how ?

4 Answers   IBM,

---

In BIND, isolation level parameter specifies the duration of page lock and ACQUIRE, RELEASE also do almost the same thing. What is the exact difference between the two? Do they work in conjunction while executing SQL queries and obtaining locks?

8 Answers   Syntel,

---

What is the difference between SYNONYM and ALIAS?

6 Answers   TCS,

---

B37 abend during spufi?

0 Answers   IBM,

---