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

What is QUIESCE?

2 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  

---

How is the SUBSTR keyword used in sql?

1 Answers  

---

What is the purpose of coding FETCH in a SQL SELECT query? Explain with an example in Detail?

4 Answers  

---

what is a trigger and types of triggers

3 Answers   HSBC,

---

What is ibm db2 used for?

0 Answers  

---

how does the defining of a stored procedure effect the size of a DB2 data base A) it increases the size of a data base B) it decreases the size of a data base C) it does not effect the size of the data base D) it changes the table space structures

2 Answers   Accenture,

---

How is the value function used?

0 Answers  

---

List out the buffer pools in db2

0 Answers  

---

Name some fields from SQLCA.

2 Answers  

---

What is a Resource Control Table(RCT)? Describe its characteristics.

3 Answers  

---

How will you delete duplicate records from a table?

7 Answers   Google,

---