What is the specific need of Plan and..where are the tables in DB2 are physically saved

3 Answers   Infosys,

---

what is Static and dynamic linking

1 Answers   Virtusa,

---

what is the use of commit ? and what is the syntax?

2 Answers   Deloitte,

---

In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?

2 Answers   Wipro,

---

If a non-DB2 program calls a DB2 program, the calling program's name will be there in SYSIN of IKJEFT01 and the plan name will be that of the called program. But is a bind needed or a plan has to be created for the non-DB2 program also?

1 Answers   RBS,

---

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 do you resolve -805?

3 Answers   HCL,

---

What are the three types of page locks that can be held?

1 Answers  

---

How to view db2 table structure?

0 Answers  

---

If there is no row in Emp table with Ename as Raghava and you run the below queries in SPUFI. 1.select Ename from EMP wher Ename = 'raghava' 2.Select count(*) from EMP where Ename = 'raghava' What is SQLCODE shown up in SPUFI

4 Answers   ADP,

---

What is db2?

0 Answers  

---

What is innodb buffer pool?

0 Answers  

---