what is the difference between declaring the cursor in WS
section and Procedure division?

Answer Posted / madhavi chava

As definition of cursor is non executable statement, it is
advisable not to define in procedure division as it may
misunderstood others.

we can define it any where only thing you have to take care
is definition of cursor should be prior to the OPEN
statement of the same cursor.

Is This Answer Correct ?    18 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to get the ddl of a table in db2?

671


What is db2?

738


What are the various isolation levels possible?

643


Which is faster delete or truncate?

671


What kind of database is db2?

565






On which levels locks can be applied?

651


If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

1572


What is the use of commit in db2?

628


Is db2 a programming language?

597


What do you mean by rollback?

568


What is meant by explain?

658


can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

1797


How is the value function used?

598


What does db2 stand for?

596


What type of database is db2?

521