Answer / s

Dynamic SQL are built at execution time. Dynamic SQL does
not go through the program preparation process like static
SQL and can execute different SQL statements in one
program.

i want to delete 20th million record how ?

4 Answers   IBM,

---

how can u understand the end of the table ?

1 Answers   TCS,

---

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,

---

wht happens if we close cursor with cursor with hold option?

3 Answers   Valtech,

---

Why use RUNSTAT Utility?

3 Answers   Merrill Lynch,

---

What is difference between rollback and commit?

0 Answers  

---

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  

---

Explain about dbrm.

0 Answers  

---

What is the maximum size of a char data type in db2?

0 Answers  

---

what is a plan and how do you refer the plan in the program?

2 Answers   Xansa,

---

What happens to the PLAN if index used by it is dropped?

1 Answers  

---

What is reorg?

0 Answers  

---