Answer / s

Correlated subquery refers to atleast one column of the
outer query. The correlated subquery is evaluated for each
qualifying row from the outer query.

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

3 Answers  

---

Can you search give an array in the WHERE clause of a db2 query?

1 Answers  

---

What Utility is used to migrate DB2 from one release to the next?

1 Answers  

---

What is a synonym? How is it used?

2 Answers  

---

How can you quickly find out the # of rows updated after an update statement?

0 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 purpose of the QUIESE Utility?

1 Answers  

---

What is DCLGEN ?

3 Answers  

---

what are bind concepts in db2 cobol?

0 Answers  

---

quary for 1> fetch last record 2> fetch in reverse order 3> fetch last 5 row 4> fetch second last record (their is no primary key) i think concept of count can be use for this in 4th

5 Answers  

---

What is precompiler in db2?

0 Answers  

---

what is the input to PLAN? what is the input to DBRM?

4 Answers  

---