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

What's The Percentage Free Space ?

1156

What is dbrm in db2 database?

1029

What does a deadlock mean in DB2?

1091

what are bind concepts in db2 cobol?

1031

What is database manager in db2?

963

What is the syntax for FETCH in DB2 ?

1136

What is commit in db2?

995

What is the advantage in De-normalizing tables in DB2?

1107

What is the difference between spufi and qmf?

1050

What is release/acquire in bind?

1054

What is the usage of open cursor command?

1032

How to view db2 table structure?

959

What do you mean by storage group (stogroup)?

983

What are union and union all?

920

Outputs of explain are with matchcols = 0. What does this signify?

988