Answer Posted / naresh.s

in DB2
first we need to know duplicate records in database file
like tmpfilep ,for that

select RRN(A) from tmpfilep A where field='fieldvalue'

here field means any fileld containd tmpfilep and
corresponding value.

once we execute the above query we will get relative record
numbers of each row and remember that numbers
now you can delete records based on these numbers

delete from tmpfilep A where rrn(A) in (234,341,642)

here 234,341,642 are sample record numbers

may be i am correct upto my knowledge.......

Is it possible using max on a char column?

1130

---

How can you count the number of rows from a table tab?

1083

---

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

1043

---

What is with ur in db2?

1296

---

What is a system catalog table in db2?

1178

---

When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

3569

---

What is dclgen (declaration generator)?

1044

---

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.

3196

---

What is the advantage in De-normalizing tables in DB2?

1162

---

What is a dbrm in db2?

1016

---

What is a db2 package?

1041

---

What is the use of with ur in db2?

1047

---

What is the physical storage length of the data types: date, time, timestamp in the db2 database?

1147

---

What is host variable?

1044

---

What is the syntax for FETCH in DB2 ?

1196

---