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 will you return the number of records in table?

937

---

What is database reorganization?

1126

---

i want to maintain uniqueness on pdf without make lf??????????

2156

---

Why db2 is called db2?

1039

---

How do I delete a column in db2?

1109

---

What are the rules for db2 programming?

1088

---

What is the physical storage length of date data type?

1253

---

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

2126

---

Give the name of some fields form sqlca.

1078

---

in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

2097

---

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

1051

---

What is buffer pool and list some of them?

1028

---

What is the usage of open cursor command?

1100

---

What is the use of with ur in db2?

1057

---

How to restart a DB2 program?

1902

---