Answer / Jitendra Kumar Yadav

In DB2, a precompiler is a utility that processes SQL source code before it is compiled or linked with the application program.

Why use RUNSTAT Utility?

3 Answers   Merrill Lynch,

---

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,

---

Define check constraint.

1 Answers  

---

How do you leave the cursor open after issuing a COMMIT? (for DB2 2.3 or above only)

2 Answers  

---

When one binds a PACKAGE ( of a plan ) what package information is stored and where it is stored?

3 Answers  

---

I want to fetch the 10th row of a table which has been changed.How can I do it without going thru all the rows.

5 Answers  

---

Under what circumstances will DB2 allow an SQL statement to update more than one primary key value at a time?

1 Answers  

---

What is dclgen (declaration generator)?

1 Answers  

---

What is database alias db2?

1 Answers  

---

What is innodb buffer pool?

1 Answers  

---

How can deadlocks be resolved?

1 Answers  

---

Define predicate?

1 Answers  

---