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 do you mean by cursor?

1029

---

What is universal database?

1116

---

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

1230

---

How to find the maximum value in a column in the db2 database?

1125

---

What is dbrm library?

1112

---

Explain the contents that are a part of dclgen.

1133

---

Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....

2410

---

How do we specify index to include or not during bind process.

2171

---

Is db2 a programming language?

1095

---

What is the maximum number of columns in a db2 table?

1342

---

Explain how can you do the explain of a dynamic sql statement?

1173

---

In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

1148

---

How can record locking be achieved in those DB2 versions which do not support it?

1122

---

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.

3259

---

How can the firstname and the lastname from the emp table be concatenated to generate complete names?

1319

---