Answer / s

133

What are union and union all?

0 Answers  

---

One program calling 5 subprograms, its a cobol db2 program, after precompilation how many plans and packages will created?

3 Answers  

---

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,

---

Mention the length of physical storage of the given data types of db2 – date, timestamp, time

0 Answers  

---

Can we declare DB2 HOST variable in COBOL COPY book?

2 Answers  

---

What is buffrpool? Where we use it ?

2 Answers   Tesco,

---

For update of a row in cursors, when do we move value into host variable in cobol progrm? is it before open or before fetch ?

2 Answers   iGate,

---

What is DCLGEN ?

3 Answers  

---

Which command is used to connect to a database in DB2 ? Give the Syntax.

0 Answers   MCN Solutions,

---

if one db2 pgm calls another db2 pgm. how many plans do we need. what r the steps involved..

4 Answers   IBM,

---

How do I optimize a query in db2?

0 Answers  

---

i have an employment table whch has salary,dept,name? i want salary b/w 1000 to 5000 can anyone pls say the query for ths ?

8 Answers   Cap Gemini, CGI, EDS, IBM, Satyam, Wipro,

---