Answer Posted / vas

Use Cursor...

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?

2472

---

Explain correlated sub-queries.

971

---

what is diffrence b/w file-aid tool and file-aid utility???

4808

---

What is buffer pool and list some of them?

980

---

What is package in db2 mainframe?

915

---

I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

2007

---

What is release/acquire in bind?

1054

---

What is lock escalation in db2?

963

---

How to find the number of rows in db2 tables?

992

---

What is db2 catalog database?

982

---

What is load replace in db2?

935

---

How do I import a csv file into db2?

936

---

How to access db2 tables in mainframe?

990

---

How to run db2 command in windows?

1134

---

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

1048

---