Answer Posted / vaneesh khurana

I think better to perform this in following 2 queries

1. Select count(WS-COUNT) from TABLE;

2. DELETE FROM TABLE WHERE ROWCOUNT(*) IS WS-COUNT OR
(WS-COUNT-1);

Basically here the first row will give you the record count
and 2nd will delete the last and the 2nd last row.

i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?

2538

---

What is the result of open cursor statement?

1085

---

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2860

---

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

1093

---

What is a db2 tablespace?

1070

---

What is null value in db2?

1032

---

What is the syntax for FETCH in DB2 ?

1222

---

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

2371

---

What is innodb buffer pool?

1063

---

What is explain plan in db2?

1005

---

What is explain in db2?

1036

---

What is host variable?

1063

---

What is the connection string to connect to the DB2 Database ?

1135

---

What is the physical storage length of time data type?

1133

---

What's The Percentage Free Space ?

1228

---