Answer Posted / sam

yes there sre diffrence.
If we declare cursor in working storage section then it is
called as static cursor without parameters from cobol.

If we declare cursor in procedure division then we can use
COBOL variables as parameters to the cursor. See the
examples for both the cases...

Eg: STATIC CURSOR

WORKING-STORAGE SECTION.
01 HV-EMPNO PIC 9(4) value 7934.
EXEC SQL
DEFINE C1 CURSOR FOR SELECT * FROM EMP WHERE EMPNO=HV-EMPNO
END-EXEC.

In the above case EMPNO is static. We cannot move a value
or read a value in to empno, because it is in working
storage section.

DYNAMIC CURSOR:

PROCEDURE DIVISION.
ACCEPT HV-EMPNO.
EXEC SQL
DECLARE C1 CURSOR FOR SELECT * FROM EMP WHERE EMPNO=:HV-
EMPNO
END-EXEC.

In the above example we can read EMPNO from another table
or file or we can take it from user. Now cursor becomes
dynamic.

I hope now its clear for you. If you need more information
let me know.

What is runstats utility in db2?

1071

---

What is bind in db2?

1098

---

What is the difference between dbm cfg and db cfg file in db2 ?

1593

---

Which isolation level provides maximum concurrency?

1208

---

What is a plan and package in db2?

1155

---

What does runstats do in db2?

1188

---

How and when does the db2 enforces the unique key?

1143

---

What's The Error Code For Unique Index Voilation?

1309

---

What is the use of runstats in db2?

1184

---

Explain the benefits you can get from mainframe connect?

1017

---

Define predicate?

1204

---

What is cloudant database?

1158

---

What is the default page size of buffer pools?

1171

---

How can you find out the # of rows updated after an update statement?

1154

---

How to rename a table in DB2 ?

1147

---