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

Are views updateable?

1163

Is db2 a mainframe?

1044

What is a storage group (stogroup)?

1247

What is the physical storage length of the data types: date, time, timestamp in the db2 database?

1160

How can deadlocks be resolved?

938

What is the use of db2?

1057

Explain package in db2 and its advantages?

1219

Define predicate?

1139

Is db2 a programming language?

1051

Differentiate between cs and rr isolation levels? Where do you specify them?

1071

What is performance tuning db2?

1064

What is meant by dclgen?

1112

What is data manager?

1051

What is package in db2 mainframe?

989

What is page size in db2?

978