Answer / valmiki1980

1. put autocomit No in spufi and run insert command
2. run the insert command thru cob-db2 program.
this results -911 error

What is the significance of DB2 free space and what parameters control it?

1 Answers  

---

What is dynamic SQL?

1 Answers   ADP,

---

When the like statement is used?

0 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  

---

what is utility for parm lib

0 Answers   IBM,

---

Mention data types used in db2 ?

0 Answers  

---

Why PS file called Physical seqential file?How to sore data in sequential file and ESDS file? What is the use of DBRM,PLAN,package and Collection.

1 Answers  

---

AGGREGATE function support by DB2. A) SUM & AVG B) SUM, MIN & AVG C) SUM, MAX, AVG , MIN &COUNT D) NONE

2 Answers   Accenture,

---

What are common abends

1 Answers   SPIC, Virtusa,

---

How does DB2 use multiple table indexes?

1 Answers  

---

what is the input to PLAN? what is the input to DBRM?

4 Answers  

---

Mention the various locks that are available in db2.

0 Answers  

---