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.

How to get the ddl of a table in db2?

1131

---

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

1107

---

What is an instance in db2?

1035

---

Mention the length of physical storage of the given data types of db2 – date, timestamp, time

1077

---

How will you return the number of records in table?

937

---

Before you give the explain statement, what are the prerogatives?

1041

---

My sql statement select avg(salary) from emp yields inaccurate results. Why?

1095

---

What is bufferpool in db2?

1054

---

What is db2 bind process?

1240

---

How can you do the explain of a dynamic sql statement?

1069

---

What is table space in db2?

1019

---

What is role in db2?

1109

---

What is scrollable cursor in db2?

1055

---

What is the syntax for seeing the columns and data types of a table in the db2 database?

1169

---

How can deadlocks be resolved?

937

---