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 the use of runstats in db2?

0 Answers  

---

Which catalog table stores referential constraints?

1 Answers  

---

db2 query I have one table with the following details. SNO SNAME DOJ ------ -------------------- ---------- 10 KRISH 2007-03-19 20 REDDY 2007-05-19 30 RRRRR 2007-05-19 40 BBBBB 2008-05-19 50 CCCCC 2009-05-19 60 JJJJJ 2009-05-19 70 JJJJJ 2004-05-19 i want the output in the following format:( no of students joined in each year(no nedd to consider about month and date) year count --------- ---------- 2004 1 2007 3 2008 1 2009 2

9 Answers   TCS,

---

How to find the number of rows in db2 tables?

0 Answers  

---

What is the difference between static and dynamic SQL?

1 Answers  

---

What is reorg and runstats in db2?

0 Answers  

---

What is the difference between SYNONYM and ALIAS?

6 Answers   TCS,

---

what is the process of precompiler?

2 Answers  

---

What os does db2 run on?

0 Answers  

---

How do you run JCL in cobol program

1 Answers   IBM, Syntel,

---

The only place of VSAM KSDS in DB2 is?

2 Answers   IBM,

---

What is the max length of sqlca?

0 Answers  

---