Answer / aditya

15 such nested level is possible.

Answer / deepak

15

Answer / sujeesh

32

Answer / saikat

255

What is QUIESCE?

2 Answers  

---

can any one expalin check point with an example?

1 Answers  

---

i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?

0 Answers   TATA,

---

What is the difference between IN subselects and EXISTS subselect?

1 Answers   HCL, PreVator, TCS,

---

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

3 Answers  

---

---

What is runstats db2?

0 Answers  

---

Which one allows duplicate values Union or Union All ?

3 Answers  

---

5 rows are inserted to a DB2 Table. Next 3 of those are updated, then a rollback is issued. What would happen when the rollback is issued?

2 Answers  

---

I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?

0 Answers  

---

How many clustering indexes can be defined for a table?

2 Answers  

---

How do you retrieve the first 5 characters of firstname column of db2 table emp?

1 Answers  

---

What do you mean by between and in? Is between inclusive of specified range values?

0 Answers  

---