Answer Posted / harish

perform until ws-flag = 'y'
exec sql
insert into table('a','b','c','d','e')
values(a,b,c,d,e)
end-exec
evaluate sqlcode
when 000
continue
when 100
move 'y' to ws-flag

according to me ,pls let me any other remedy

How would you find out the total number of rows in a db2 table?

998

---

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.

3154

---

What is difference between rollback and commit?

1104

---

What are union and union all?

935

---

How to resolve deadlock issue

19907

---

What is scrollable cursor in db2?

1014

---

What is the syntax for creating a table in the db2 database?

1068

---

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?

2487

---

What is the cobol picture clause of the db2 data types date, time, timestamp?

1024

---

How can tablespace be moved to another dasd volume that is allocated for that tablespace?

1194

---

When the like statement is used?

1170

---

What is nvl in db2?

1052

---

Explain in detail about buffer manager and its functionalities?

1010

---

What is the difference between plan and package in db2?

1053

---

What is the role of data manager in the db2 database?

1061

---