What if we fail to give values in columns declared as NOT NULL ?

3 Answers   Cap Gemini,

---

Discuss about db2 bind?

0 Answers  

---

Could you please let me no the query for below I have table name xyx under this there is column name called employee name which starts from 100th column ends 120th column,now i want to replace only column from 101 to 104 which contains ABCS to replace with PQRS for all records which comes beetween 101 to 104 ..how to write query for this..

1 Answers   HSBC,

---

I have a DB2 table which has 1000 rows.after udatingg first 110 rows, my job abends. Now what I have to do if I want to restart the job next time so that it should start updating from 111th row (without updating first 110 rows again).

10 Answers   Cap Gemini, Wipro,

---

what is Static and dynamic linking

1 Answers   Virtusa,

---

What is the format (internal layout) of ?TIMESTAMP??

1 Answers  

---

How does DB2 store NULL physically?

2 Answers  

---

What is lock escalation?

2 Answers  

---

How to insert more than one record using insert?

7 Answers   Atos Origin, IBM,

---

What is the meaning of -805 SQL return code?

3 Answers  

---

Hi. I am currently working as a application developer. I would like to persue a DB2 certification exam. Can anybody please provide me the details about this exam like Syllabus, Cost and how to take the certification?

2 Answers  

---

What techniques are used to retrieve data from more than one table in a single SQL statement?

2 Answers  

---