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 performance tuning db2?

0 Answers  

---

Q4. How will you get the count of record without using COUNT verb in query?

2 Answers   IBM,

---

how can u understand the end of the table ?

1 Answers   TCS,

---

What is copy pending status in db2?

0 Answers  

---

COBOL PRECOMPILER ERROR: "XXXXXX" (TABLE) PREVIOUSLY DECLARED OR REFERENCED DCLGEN VARIABLES GETS IMPORTED TWICE FOR ONLY ONE EXEC SQL STATEMENT. WHAT COULD BE THE PROBLEM?

1 Answers  

---

what is the difference between where clause and having clause

2 Answers   IBM,

---

what will be the output of the below given query, if no matching records are found : (a.) 0 (b.) null (c.) error select Avg(salary) from TableA where Deptno = 'insurance'

10 Answers   Amdocs,

---

What information is used as input to the bind process?

2 Answers  

---

Mention and explain the contention situations caused by locks?

1 Answers  

---

What is a page in db2?

0 Answers  

---

What is the logical entity between plan and Package?

5 Answers  

---

How to create backup table in db2?

0 Answers  

---