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  

---

How to resolve -504 sql code in DB2?

2 Answers   Cap Gemini,

---

What is the COBOL picture clause for a DB2 column defined as DECIMAL(11,2)?

5 Answers   Emsang,

---

Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?

2 Answers  

---

What is database reorganization?

0 Answers  

---

---

i have one file having 100 of records? i want to display it like 20 records in one column and 20 records in another column total 40 records per page ? how ?

2 Answers   EDS,

---

How do you simulate the explain of an embedded sql statement in spufi/qmf?

0 Answers  

---

what is contained in the DB2 node lock file? A) data base names B) data base users names C) license keys D) server names

5 Answers   Accenture,

---

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

0 Answers  

---

what is copy pending and check pending ?

1 Answers   Xansa,

---

What is REORG? When is it used?

4 Answers  

---

What is DCLGEN?

2 Answers  

---