File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

0 Answers   Infosys,

---

If I have 5 Queries in a DB2 Cobol program , while precompiling how many DBRMs will get created and How many Plans and Packages will get created while Bind Process?

8 Answers   Accenture,

---

How do you declare a host variable (in COBOL) for an attribute named emp-name of type VARCHAR(25) ?

2 Answers   IBM, Tech Mahindra,

---

what is the syntax for FOR UPDATE CLAUSE in cursor declaration and how can u update using cursor? is it possible to update multiple rows at a time.

2 Answers   Syntel,

---

what is the total syntax for fetch ? can any one please give me all the details of fetch ? thx

2 Answers   IBM,

---

What is the use of COMMAREA ?Minimum how much data we can pass from it?

7 Answers   Cap Gemini,

---

When can an insert of a new primary key value threaten referential integrity?

2 Answers   Mind Tree,

---

When is the access path determined for dynamic SQL?

2 Answers  

---

What if we fail to give values in columns declared as NOT NULL ?

3 Answers   Cap Gemini,

---

i hav created a program and moved to production but failed to create the table which is been used in the program. the program shows error as soon as it is moved or installed in production or shows error during its runtime. what is the sqlcode for this error

3 Answers   UST,

---

How many buffer pools are available in db2?

2 Answers  

---

Explain correlated sub-queries.

0 Answers  

---