Answer Posted / 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 types of tables are there in the db2 database?

1004

---

What is the advantage in De-normalizing tables in DB2?

1114

---

What is the default page size of buffer pools?

1069

---

What does db2 blu stand for?

1100

---

Why select is not preferred in embedded sql programs?

1228

---

Which component is used to execute the sql statements?

1052

---

What is explain plan in db2?

941

---

How to check last update on table in db2?

1001

---

What db2 400?

1103

---

What is the use of db2?

1005

---

What is universal database?

1029

---

How to find the number of rows in a db2 table?

1062

---

run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...

4214

---

Name the lockable units in DB2?

1072

---

How can you do the explain of a dynamic sql statement?

1012

---