Mention data types used in db2 ?

0 Answers  

---

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  

---

Explain in detail about buffer manager and its functionalities?

0 Answers  

---

What technique is used to retrieve data from more than one table in a single SQL statement?

9 Answers   CTS, IBM, TCS,

---

How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause)

2 Answers  

---

Where is the access path logic created by the DB2 Optimizer stored?

1 Answers  

---

what is main use of table space and index object? please its urgent

5 Answers   CA, Cap Gemini, CGI, CTS, EDS, HTC, IBM, Satyam, Syntel, TCS, Wipro,

---

In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

0 Answers  

---

What is difference between *omit and *nopass?

1 Answers   IBM, TCS,

---

How to resolve -818 sql code in DB2?

2 Answers   Cap Gemini,

---

What is meant by union and union all?

0 Answers  

---

How to find the number of rows in a db2 table?

0 Answers  

---