What is tablespace?

3 Answers  

---

I HAVE 2 TABLES ONE IS EMP_TABLE AND ANOTHER DEPT_TABLE.EMP_TABLE CONTAINS NAME,DEPTNO,DEPTNAME,LOCATION AND DEPT_TABLE CONTAINS DEPTNO,DOJ(DATE OF JOINING).I WANT TO DISPLAY NAME,DEPTNAME,DOJ AND WHO ARE JOINED BETWEN 01- JAN-2007 TO 01-JAN-2008?

6 Answers   Perot Systems,

---

I have two tables A and B. Both tables are connected with SSN number as foreign key. I want to retrieve a column data from B table. How will you write a query?

3 Answers   CTS,

---

How do I change the column size in db2?

0 Answers  

---

What is a correlated sub query?

2 Answers  

---

What is the difference between IN subselects and EXISTS subselect?

1 Answers   HCL, PreVator, TCS,

---

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,

---

which is the most efficient tablespace?? a.simple tablespace. b.partitioned tablespace. c.segmented tablespace. d.none of the above. please post answer with the reason.?

3 Answers  

---

Which command is used to connect to a database in DB2 ? Give the Syntax.

0 Answers   MCN Solutions,

---

Mention the definition of cobol in varchar field.

0 Answers  

---

What is CHECK PENDING ?

5 Answers  

---

Give the name of some fields form sqlca.

0 Answers  

---