What is a Resource Control Table(RCT)? Describe its characteristics.

3 Answers  

---

How will you return the number of records in table?

0 Answers  

---

What is commit in db2?

0 Answers  

---

Is it possible using max on a char column?

0 Answers  

---

difference between group clause and order clause

1 Answers  

---

---

What is the syntax for creating a table in the db2 database?

0 Answers  

---

When is the access path determined for dynamic SQL?

2 Answers  

---

EXPLAIN has output with MATCHCOLS = 0. What does it mean?

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

---

What is REORG? When is it used?

4 Answers  

---

In cobol+DB2program if the code of cobol program has changed than i have to do precompilation once again?

6 Answers   TCS,

---

by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

4 Answers   Mphasis,

---