You can Declare Cursor either in Working-storage section or in Procedure

When is the results table for the query in a DECLARE CURSOR
statement created?

Question Posted / biswamoy

5 Answers
9257 Views
I also Faced
E-Mail Answers

Answer Posted / biswamoy

You can Declare Cursor either in Working-storage section or
in Procedure division. It is not executable

OPEN CURSOR is executable ( here it creates Result), Fetch
rows within loop then close cursor.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain dclgen.

1206

What os does db2 run on?

986

Can we delete records from view?

967

B37 abend during spufi?

1455

What is explain plan in db2?

996

What is innodb buffer pool?

1055

What is a dbrm in db2?

1021

On which levels locks can be applied?

1133

What type of database is db2?

971

What is dbrm? When it will be created?

1029

What is ibm db2 used for?

1081

What is the default page size of buffer pools?

1122

How is a typical db2 batch pgm executed?

1176

What is lock escalation in db2?

1033

What is the latest version of ibm db2?

1269