Answer / amarnadh reddy

If we set SQLCODE=100 means end of the table.

EX: if sqlcode=100
Display end of the table
end-if.

What is a db2 cursor?

0 Answers  

---

AGGREGATE function support by DB2. A) SUM & AVG B) SUM, MIN & AVG C) SUM, MAX, AVG , MIN &COUNT D) NONE

2 Answers   Accenture,

---

Hi this is sures. i need to practice the ibm mainframes.could u telme how can i get userid from IBM.how much cost they will collect for one user id.can send me the details please.thanq

2 Answers  

---

What are the four lockable units for DB2?

1 Answers  

---

What are the contents of a DCLGEN?

4 Answers   MetLife,

---

---

Describe the elements of the SELECT query syntax?

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

---

Are views updateable?

0 Answers  

---

Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?

2 Answers  

---

What techniques are used to retrieve data from more than one table in a single SQL statement?

2 Answers  

---

Mention the different locking levels that are available in db2.

0 Answers  

---

What are iseries servers?

0 Answers  

---