What are column-name qualifiers used?

1 Answers  

---

What is a predicate?

1 Answers  

---

Say CUST Table contains records like: CUSTNO CUSTNAME CUSTLOC 100 ABC SSS 200 XYZ 300 PQR 400 MNO WWW 500 CVV ------------- ------------- Now write a query to retrieve all records with CUSTLOC no data.

3 Answers   IBM,

---

What is cursor in dbms?

0 Answers  

---

In terms of DB2 indexing, what is the root page?

1 Answers  

---

What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

0 Answers  

---

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 a Resource Control Table(RCT)? Describe its characteristics.

3 Answers  

---

What is filter factor?

2 Answers  

---

What do you mean by NOT NULL WITH DEFAULT? When will you use it?

3 Answers  

---

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

0 Answers  

---

What should be specified along with a cursor in order to continue updating process after commit?

1 Answers   IBM,

---