What is a db2 tablespace?

0 Answers  

---

What is precompiler in db2?

0 Answers  

---

What is a recovery log?

1 Answers  

---

What is the self-referencing constraint?

2 Answers  

---

db2 restart logic ?

1 Answers   DELL, HTC, UHG,

---

What are column-name qualifiers used?

1 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,

---

My cobol program(not having any sql statements) is calling another cobol program ( having sql statements), what is needed for compilation and run in jcls .

3 Answers   Cap Gemini, RBS,

---

I have a table name Table1 which contain columns Cust_no, car_model, country, salesamt. The records are 101, Fiat, India, 12345 2nd record is 102, Tata, USA, 98743 3rd record is 101, indica, India, 65342 4th record is 103, Toyota, UK, 64522 5th record is 103, Maruti, USA, 98632 and so on..... Now my question is write sql query which will give me detail about the sum of sales amount in perticular country

2 Answers   IBM,

---

what are the max. & min. no. of partitions allowed in a partition tablespace?

2 Answers   IBM,

---

How do I copy a table in db2?

0 Answers  

---

Where are plans stored?

2 Answers  

---