Answer / bhavna

A plan is an executable module containing the access path
produced by DB2 optimizer.

Answer / shashidhar.k.

Plan is load module for SQL statements

Answer / s

An application program cannot run without a plan. A Plan is
created by BIND PLAN, by binding DBRMS, packages or DBRMS
and packages together.

What else is there in the PLAN apart from the access path?

1 Answers  

---

How do run the JCL which has 25 steps by skipping the following steps 5, 10,15 and 25 without using COND statement

5 Answers   Syntel,

---

What if , we failed to mentioed null indicator in sql select query , that may retrieve null value ?

2 Answers   Cap Gemini,

---

suppose in my table 10 rows are there , i want to update odd rows salary as 90000 ? how u do it ? any one help me ? what do we use here cursor-fetch or normal sql ?

5 Answers   IBM,

---

in my table i will update only 100 record among 1000 records i need to display recently updated record'.....can u tell me where those records are stored how can i display those records...?if there is any sql query pls let me know....?

3 Answers   Infosys,

---

What is Declaration Generator(DCLGEN)?

1 Answers  

---

Is Cursor exicutable ?

3 Answers   TetraSoft,

---

Hi , I am posting some interview ques . what is the use of cursors ? what is the diff between select and cursor ? bith are used for data retrival .. rite?

2 Answers   Deloitte,

---

What are catalog tables in db2?

0 Answers  

---

Can we able to find all the Table names under a Particular Plan?

1 Answers   CTS,

---

What is cursor in dbms?

0 Answers  

---

What is release/acquire in bind?

0 Answers  

---