Answer Posted / nirmal khatri

Hi

We can do it by SQL also, below is SQL which is working on
iSeries(AS/400)

insert into nk11581/temp1 (select * from nk11581/temp1
where rrn(temp1) in(
SELECT distinct dec((rrn(temp1)/2)) FROM nk11581/temp1
))

Define buffer pool.

1062

---

Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

1063

---

What is the usage of open cursor command?

1103

---

What is the use of db2?

1060

---

What is buffer pool in the db2 database?

1111

---

What is access path in db2?

990

---

What is the difference between dbm cfg and db cfg file in db2 ?

1540

---

What is alias in db2?

1068

---

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

1095

---

If I have a view which is a join of two or more tables, can this view be updateable?

1139

---

How does a cursor work?

994

---

Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.

2727

---

What is the syntax for seeing the columns and data types of a table in the db2 database?

1171

---

Can you use max on a char column?

1097

---

How do you select a row using indexes in db2?

1140

---