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 is host variable in db2 cobol?

1028

---

Give the name of some fields form sqlca.

1021

---

by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

8994

---

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

2312

---

What is the physical storage length of date data type?

1189

---

What is a bind in db2?

982

---

What is db2 look?

970

---

What is multi row fetch in db2?

986

---

Are views updateable?

1070

---

How is the value function used?

1080

---

Can there be more than one cursor open for any program?

1123

---

What is difference between alias and synonym in db2?

1067

---

What is db2 instance?

1016

---

what are bind concepts in db2 cobol?

1034

---

What do you mean by cursor?

942

---