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  

---

I have a table which has thousand of records i want to fetch only record num 100 to record num 200. Write a query that satisfies this criteria.(Cant use any keys) Anyone please reply ASAP!

17 Answers   KNIT, Tech Mahindra,

---

wht steps we need will coding cobol and db2 pgm ?

6 Answers   CGI,

---

How do you define a correlated name?

1 Answers  

---

What is a collection?

3 Answers  

---

---

Why do we use cursor?

0 Answers  

---

What techniques will be used to avoid deadlock??

5 Answers   IBM, SUN,

---

Which transaction use a command thread ?

1 Answers  

---

What is a collection in db2?

0 Answers  

---

what is the difference between join and union?

4 Answers   IBM,

---

What are the different methods of accessing db2 from tso? How is the connection established between TSO & DB2?

3 Answers   Tech Mahindra,

---

How do you concatenate the firstname and lastname from emp table to give a complete name?

0 Answers  

---