How to find the number of rows in a db2 table?

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,

---

What is sqlca’s maximum length?

0 Answers  

---

Name some fields from SQLCA.

2 Answers  

---

How to handle null values in db2

4 Answers  

---

Define db2.

0 Answers  

---

wht happens if we close cursor with cursor with hold option?

3 Answers   Valtech,

---

How we create a tables in DB2 ?Previously client has using 7 letters for user id,now he wants to increase the letters from 7 to 12 for user id.How we can do it?

6 Answers   Wipro,

---

Mention the way of highlighting as well as putting a cursor to use in a cobol program.

0 Answers  

---

What is the specific need of Plan and..where are the tables in DB2 are physically saved

3 Answers   Infosys,

---

What is the difference between static and dynamic SQL?

1 Answers  

---

How to insert more than one record using insert?

7 Answers   Atos Origin, IBM,

---