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  

---

1. what if null values retrived from database and no null indicator mentioned in query. What is sql code.

1 Answers   Cap Gemini,

---

Define db2.

0 Answers  

---

what is Static and dynamic linking

1 Answers   Virtusa,

---

What are data types?

2 Answers  

---

When one binds a PACKAGE ( of a plan ) what package information is stored and where it is stored?

3 Answers  

---

What is dbrm? What it contains?

0 Answers  

---

What is a precompiler?

2 Answers  

---

What error I will get if my select query gives multiple row while executing a Cobol-DB2 program.How can I solve it without using a cursor.

4 Answers   Cap Gemini, Verizon,

---

Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....

0 Answers  

---

the dd name for ksds is dest1 and what is the dd name for alternate index of ksds ? a.dest b.dest1 c.dest1a d.dd1

2 Answers   Logica CMG,

---

what is copy pending and check pending ?

1 Answers   Xansa,

---