Answer / s

DSN Command invokes the DB2 command processor.

Answer / dhanya

tso db2 is the command

what is the process of precompiler?

2 Answers  

---

if suppose i am having an ACCOUNT table with 3 coloumns ACC. NO,ACC. NAME,ACC. AMOUNT . If a unique index is also defined on ACC.NO and ACC.NAME then write a query to retrieve account holders records who have more than 1 ACC.

8 Answers   Wipro,

---

select 100 records from million records ?

2 Answers   Verizon,

---

What is the maximum No of rows per page?

0 Answers   IBM,

---

What is a db2 schema?

0 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 the purpose of rollback and commit?

0 Answers  

---

What is a SELECT statement?

1 Answers  

---

What is the difference between CS and RR isolation levels?

1 Answers  

---

What's The Percentage Free Space ?

0 Answers   IBM,

---

what are stage one indexable predicates?

1 Answers  

---

1. what if null values retrived from database and no null indicator mentioned in query. What is sql code.

1 Answers   Cap Gemini,

---