how do we solve soc 7 and soc4 ?

3 Answers   Tech Mahindra,

---

Consider that a package is bound into 2 different collections and the PKLIST option specifies both the collections. If the collection id is not specified in the program while executing the SQL query, then when the DB2 system will search the package list, which collection will it pick up or will it give an error/abend?

1 Answers  

---

List down the data types in the db2 database.

0 Answers  

---

What does reorg do in db2?

0 Answers  

---

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

7 Answers   Cap Gemini,

---

Explain about rct.

0 Answers  

---

What is sqlcode -811?

7 Answers   Accenture, CTS, TCS,

---

SI Stud name Subject Marks Pass/Fail 1 Sham Maths 40 P 1 Sham Physics 50 P 1 Sham Bio 20 F 2 Ram Maths 40 P 2 Ram Physics 50 P 2 Ram Bio 60 P For the above data , write the SQL query for the student who passed in all the subjects . For eg : I want the data of only Ram coz he passed all subjects .

2 Answers   Cognizant,

---

What is the maximum number of columns in a db2 table?

0 Answers   IBM,

---

What is the difference between Where and Having Clause

7 Answers   IBM, iFlex,

---

What is a collection in db2?

0 Answers  

---

Discuss about db2 bind?

0 Answers  

---