Answer / madhavi chava

As definition of cursor is non executable statement, it is
advisable not to define in procedure division as it may
misunderstood others.

we can define it any where only thing you have to take care
is definition of cursor should be prior to the OPEN
statement of the same cursor.

What is difference between rollback and commit?

0 Answers  

---

What information can you find in SYSIBM.SYSLINKS table?

1 Answers   TCS,

---

How to take backup of table in db2?

0 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,

---

if i made sme changes in sub pgm wht r the things to be done for this ?

1 Answers   TCS,

---

---

What is dclgen (declaration generator)?

0 Answers  

---

What does CURRENTDATA option in bind indicate

1 Answers   IBM,

---

What does DML stand for and what are some examples of it?

3 Answers   IBM,

---

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

1 Answers   Syntel,

---

In BIND, isolation level parameter specifies the duration of page lock and ACQUIRE, RELEASE also do almost the same thing. What is the exact difference between the two? Do they work in conjunction while executing SQL queries and obtaining locks?

8 Answers   Syntel,

---

what is differnece between DROP TABLE & DELETE TABLE .

4 Answers   Cap Gemini,

---

Give a brief description of db2 isolation levels?

0 Answers  

---