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.

what is static sql? what is dynamic sql? Give me details

3 Answers  

---

Are view updateable?

0 Answers  

---

what is difference between random and sequence file access

1 Answers   Syntel,

---

What is index cardinality?

3 Answers  

---

can i code union in cobol-db2 pgm ?

4 Answers   Patni,

---

---

Before you give the explain statement, what are the prerogatives?

0 Answers  

---

What are the three types of page locks that can be held?

1 Answers  

---

Q3. How will you fetch duplicate values from a DB2 table?

2 Answers   RBS,

---

What is db2 catalog database?

0 Answers  

---

What are types of indexes?

0 Answers  

---

Can we update view in db2?

0 Answers  

---

How we create a tables in DB2 ?Previously client has using 7 letters for user id,now he wants to increase the letters from 7 to 12 for user id.How we can do it?

6 Answers   Wipro,

---