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
))

What are the full forms of spufi and dclgen and why are they used?

1087

---

Define declaration generator (dclgen).

1114

---

What action db2 takes when a program aborts in the middle of a transaction?

1154

---

What is runstats and reorg in db2?

1304

---

I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.

3207

---

What is the use of reorg in db2?

1084

---

what is diffrence b/w file-aid tool and file-aid utility???

4890

---

B37 abend during spufi?

1455

---

SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

11673

---

What is load utility in db2?

1181

---

Explain the function done by data manager?

1280

---

Where do you specify them?

1279

---

What is an instance in db2?

1033

---

What is dbrm? What it contains? When it will be created?

1050

---

What is a collection in db2?

1034

---