Answer / s

The CREATE statment is stored in the SYSIBM.SYSVIEWS

What is auditing?

2 Answers  

---

Is db2 a mainframe?

0 Answers  

---

Explain about cursor stability?

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,

---

i want to maintain uniqueness on pdf without make lf??????????

0 Answers  

---

Select empno, sal from emptbl where empno < 101.By this query can we fetch first 100 recs? where empno is primary key.It won't throw -811 error? if it wont,then what is use of cursor technique while fetching first 100 recs. Please need more clarification.

2 Answers  

---

Mention the various locks that are available in db2.

0 Answers  

---

How to define the data items to receive the fetch items for the SQL?

2 Answers  

---

is it compulsory commitment control in journal?

0 Answers   TCS,

---

select * from orders where odate between '2010-01-01'and '2010-03-31' How do u fetch this into cursor?

2 Answers  

---

What is the purpose of the WHENEVER statement?

1 Answers  

---

difference between group clause and order clause

1 Answers  

---