Answer / naveen87ginjupalli

SQLCODE, SQLERRM, SQLERRD.

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 do you do the EXPLAIN of a dynamic SQL statement?

2 Answers  

---

What are the various locking levels available?

3 Answers  

---

assume ther are 5000 records in a database and want to fetch using cursor. cursor fetches only 3000 records and fetch is not happening for remaining 2000 records. why it happens and how to rectify it

1 Answers   TCS,

---

can we view the access paths created by dbrm ? how ? thx

2 Answers   IBM,

---

When can an insert of a new primary key value threaten referential integrity?

2 Answers   Mind Tree,

---

can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?

1 Answers  

---

What is the physical storage length of the data types: date, time, timestamp in the db2 database?

0 Answers  

---

What is the SQL query to select, delete and get count of duplicate rows in DB2?

2 Answers  

---

what needs to be done if a table is in copy pending / check pending status?

5 Answers   Xansa,

---

What is precompiler in db2?

0 Answers  

---

What is a collection?

3 Answers  

---