Answer / sadiq afroze

EXPLAIN is used to display the access path as determined by
the optimizer for a SQL statement. It can be used in SPUFI
(for single SQL statement) or in BIND step (for embedded
SQL). The results of EXPLAIN is stored in U.PLAN_TABLE
where U is the authorization id of the user

pls explain the precompilation process of cobol-db2 pgm

3 Answers   HCL, IBM,

---

which authority can be granted to group of users using the GRANT stmt? A) SYSCTRL B) SYSADM C) DBCTRL D) DB ADM

3 Answers   Accenture,

---

What is Reorg Recovery? when will you run it?

2 Answers  

---

Is DECLARE TABLE in DCLGEN necessary? Why it used?

3 Answers  

---

What are the four lockable units for DB2?

1 Answers  

---

where can we use index and subscript ? with example ?

3 Answers   CTS,

---

can we view the access paths created by dbrm ? how ? thx

2 Answers   IBM,

---

in the CURSOR declare statement, if i am using an where clause and trying to compare the value with a host-varialble. EXEC SQL DECLARE C1 CURSOR FOR SELECT DEPTNO, DEPTNAME, MGRNO FROM DEPARTMENT WHERE ADMRDEPT = :ADM-DEPT Where would i need to provide value to this host-variable in the where clause. how could i pass value to this host-variable to check it.

2 Answers   iGate,

---

What is check constraint. Explain with example.

0 Answers  

---

Name some fields from SQLCA

1 Answers  

---

What is an instance in db2?

0 Answers  

---

in db2, already 10 columns arie der, and i want to insert 11th column. what parameters u wil consider for insertion and how will u insert

1 Answers   TCS,

---