What is query_cache_limit?

0 Answers  

---

How to check last update on table in db2?

0 Answers  

---

i have one file having 100 of records? i want to display it like 20 records in one column and 20 records in another column total 40 records per page ? how ?

2 Answers   EDS,

---

Are views updatable ?

4 Answers  

---

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

0 Answers  

---

Define check constraint.

0 Answers  

---

What is the syntax for FETCH in DB2 ?

0 Answers   MCN Solutions,

---

What is pagespace?

1 Answers  

---

How is the value function used?

0 Answers  

---

How do you simulate the explain of an embedded sql statement in spufi/qmf?

0 Answers  

---

in the CURSOR declare statement, if i am using an where clause and trying to compare the value with a host-varialble. EXEC SQL DECLARE C1 CURSOR FOR SELECT DEPTNO, DEPTNAME, MGRNO FROM DEPARTMENT WHERE ADMRDEPT = :ADM-DEPT Where would i need to provide value to this host-variable in the where clause. how could i pass value to this host-variable to check it.

2 Answers   iGate,

---

My sql statement select avg(salary) from emp yields inaccurate results. Why?

0 Answers  

---