Answer / s

EXPLAIN, determines the access path that will be used by
DB2 to execute that particular SQL statment. The results
are written to the PLAN table.

How do I create a table MANAGER (EMP-NO, MANAGER) where MANAGER is a foreign key which references to EMP-NO in the same table? Give the exact DDL.

3 Answers  

---

Can SQL statements/queries be included in a copybook?

2 Answers  

---

What is schema in db2?

0 Answers  

---

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

4 Answers  

---

Which are the db2 tools to protect integrity of the database?

0 Answers   IBM,

---

ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE

0 Answers  

---

What are column-name qualifiers used?

1 Answers  

---

Can a unique index have more than one null value? If not, what error code is given if an attempt is made to insert more than one null value?

3 Answers  

---

how can you copy records present in a flat physical file to a database file(physical file).please explain in rpg400 with a simple example

1 Answers   CTS,

---

How do I change the column size in db2?

0 Answers  

---

Is there any advantage to denormalizing DB2 tables?

1 Answers  

---

What is the command used by TSO users to invoke DB2?

2 Answers   IBM,

---