select distinct(empid),distinct(dept),name from EMP will the above query work?

2 Answers   CTS,

---

how to copy the host variables from ps file into cobol program other than include statement

1 Answers   Syntel,

---

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,

---

How to test SQL -911 error while developing COB-DB2 program

1 Answers   Satyam,

---

What does it mean if the null indicator has -1, 0, -2?

1 Answers  

---

---

What are foreign keys in db2?

0 Answers  

---

Can we declare DB2 HOST variable in COBOL COPY book?

2 Answers  

---

What is a buffer pool?

2 Answers  

---

What is the function of logging in the db2 database?

0 Answers  

---

How many buffer pools are available in db2?

2 Answers  

---

What is difference between rollback and commit?

0 Answers  

---

Which catalog table stores referential constraints?

1 Answers  

---