Answer Posted / yuvaevergreen

step1>>put all the sql statements in cobol program inside
exec sql and end-exec.Because precompiler identifies using
sql using these keywords.
step2>>all sql statements should be within 12th and 72th
column in program.
step3>>Include the dclgen if created or use the host
variable declaration name and sqlca.
step4>>precompile,compile,bind,linkedit and execute.

What is the use of reorg in db2?

1077

---

What is db2 purescale?

993

---

What is the default page size of buffer pools?

1120

---

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?

9184

---

Why do chiropractors use drop table?

1101

---

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

1163

---

What is commit in db2?

1046

---

What is the difference between cursor stability and repeatable read isolation levels?

1168

---

What do you mean by storage group (stogroup)?

1036

---

What is dbrm?

1100

---

is it compulsory commitment control in journal?

2474

---

Discuss about db2 bind?

1088

---

How to create db2 table in mainframe?

1152

---

Are views updateable?

1148

---

How to fetch the last row from the table in SQL (db2)?

1649

---