while declearing the cursor in working-storage section 'with hold�

DB2: A calls B once sucessfull and second time when it
calls says curson is open why is it so?

Question Posted / sunil

Answer Posted / sunil

while declearing the cursor in working-storage
section 'with hold' option is used due that's why cursor
remains open while next processing

Is This Answer Correct ?

8 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Mention some fields that are a part of sqlca.

1052

Define data page.

1078

On which levels locks can be applied?

1145

What are the contents of a dclmgen?

1137

What is the use of db2 optimizer?

1125

What is ibm db2 client?

948

What language is db2 written in?

1055

What is db2 bind?

1090

Why do we use cursor?

1109

What is db2? Explain.

1057

What parameters are used to control the free space in DB2?

1067

List out the three types of page locks that can be held.

1153

How does cobol compile db2 program?

1084

What is cursor stability in db2?

1366

How to find the number of rows in a db2 table?

1127