Answer / s

Subselect is a SELECT in the WHERE clause, providing values
to the outer select to get the qualifying rows. You can use
up to 225 subselects in a single SQL which are called
nested selects or nested subselects.

What are the two types of logging in the db2 database? Explain them.

0 Answers  

---

Is db2 free?

0 Answers  

---

What is a clustered index?

1 Answers  

---

When is the authorization check on DB2 objects done - at BIND time or run time?

1 Answers  

---

What is ALTER ?

3 Answers  

---

What's the difference between DB2 active log and archive log? Thanks a lot...

2 Answers   IBM,

---

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 catalog database in db2?

0 Answers  

---

What technique is used to retrieve data from more than one table in a single SQL statement?

9 Answers   CTS, IBM, TCS,

---

when we are tying to update a table having 100 rows. if the program abends when updating 51 row . how to start updating again from the 51 row .what was the logic

2 Answers   TCS,

---

where can we use index and subscript ? with example ?

3 Answers   CTS,

---

how do you resolve -818 error in db2. where we have to see time stamp token. i said by seeing in load module and plan .is it correct or not. give clear explination for how to see time stamp token

2 Answers   IBM, TRD,

---