My SQL is not performing well. Describe how will you fine tune it?

1 Answers   Accenture,

---

When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

0 Answers   Broadridge,

---

Can All Users Have The Privilege To Use The SQL Statement Select (DML)?

1 Answers  

---

What is a result table?

1 Answers  

---

What do you mean by NOT NULL? When will you use it?

3 Answers  

---

What are the 4 environments which can access DB2 ?

2 Answers  

---

What is DCLGEN?

2 Answers  

---

what is plan? is plan executable or package?

4 Answers  

---

we can code COPY DCLGEN or INCLUDE DCLGEN, At which stage of the precompilation , dclgen get expanded if we write 1) copy 2) include one question about dclgen.. Is it mandatory to use declare table in dclgen.. I think no...but it will be used by the precompiler to validate the table name,column name etc.., can one clear my doubt ..is it necessary to include declare table or not?

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 db2 bind?

0 Answers  

---

How we create a tables in db2,what is the process/syntax to create a table with example plz?

2 Answers  

---