What is the difference between base table and view?

7 Answers  

---

What is multi row fetch in db2?

0 Answers  

---

wht displays the number of times a query modified ?

2 Answers   TCS,

---

How does db2 sample database connect?

0 Answers  

---

what is the difference between join and union?

4 Answers   IBM,

---

What is rebind in db2?

0 Answers  

---

How to insert more than one record using insert?

7 Answers   Atos Origin, IBM,

---

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,

---

Explain about rct.

0 Answers  

---

List down the data types in the db2 database.

0 Answers  

---

1) I have 3 programs : PGMA, PGMB, PGMC. PGMA calls PGMB and PGMB calls PGMC. I have to do inserts, updates in all the 3 pgms. 2) Say PGMC has done its work successfully and returned to PGMB 3) PGMB had an SQL error while doing some update 4) PGMA has already done some updates before calling PGMB all are running under the same CICS region. What will happen if I issue SYNCPOINT ROLLBACK in PGMB when it abends ? Does all the changes in PGMA,B,C rollback ? (because all the pgms belong to same task).

1 Answers  

---

i have a table like this : Name ADDRESS Toto 123 ... Toto 456 ToTo 678 I would like to delete 2 last row...please tell me how to delete its

5 Answers   EDS,

---