I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

1 Answers   HeadStrong,

---

What is a DB2 catalog?

2 Answers  

---

What is concurrency in db2?

1 Answers  

---

What is RUNSTATS?

3 Answers  

---

Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?

2 Answers  

---

---

List down the types of triggers in the db2 database?

0 Answers  

---

what will be the output of the below given query, if no matching records are found : (a.) 0 (b.) null (c.) error select Avg(salary) from TableA where Deptno = 'insurance'

10 Answers   Amdocs,

---

I am having n number of records in a table which consists of emp-name is one of the field among them. Now i want to change the first letter of every name with capital.

1 Answers   Cap Gemini,

---

What is the syntax for creating a table in the db2 database?

0 Answers  

---

How do I optimize a query in db2?

0 Answers  

---

What is a thread?

3 Answers  

---

What is a db2 table?

0 Answers  

---