What is a storage group (stogroup)?

0 Answers  

---

How to check table size in db2 sap?

0 Answers  

---

Generally if I want to select the names starting with c I need to use c% But how could I code to select the data which contains % as a part of data.

5 Answers  

---

What are leaf pages?

3 Answers  

---

What is a cursor?

2 Answers  

---

List down the types of triggers in the db2 database?

0 Answers  

---

Can DASD types assigned to storage groups be intermixed (i.e., 3350s and 3380s)?

1 Answers  

---

query to just fetch first matching row and stop execution. once one matching row is found ..no more records should be checked.. if the first record is matching.. the query must stop

2 Answers   IBM,

---

i hav created a program and moved to production but failed to create the table which is been used in the program. the program shows error as soon as it is moved or installed in production or shows error during its runtime. what is the sqlcode for this error

3 Answers   UST,

---

db2 query I have one table with the following details. SNO SNAME DOJ ------ -------------------- ---------- 10 KRISH 2007-03-19 20 REDDY 2007-05-19 30 RRRRR 2007-05-19 40 BBBBB 2008-05-19 50 CCCCC 2009-05-19 60 JJJJJ 2009-05-19 70 JJJJJ 2004-05-19 i want the output in the following format:( no of students joined in each year(no nedd to consider about month and date) year count --------- ---------- 2004 1 2007 3 2008 1 2009 2

9 Answers   TCS,

---

What is QUIESCE?

2 Answers  

---

How to get the ddl of a table in db2?

0 Answers  

---