what is the difference between declaring the cursor in WS
section and Procedure division?
Answer / 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 |
what is + sign and -ve sign for sql code ?
Explain about rct in db2?
What do you mean by cursor?
How to connect to db2 database from windows command line?
What is normalization and what are the five normal forms?
What are the contents of a DCLGEN?
difference between group clause and order clause
What os does db2 run on?
Is db2 a mainframe?
What is a DB2 bind?
a cursor normally gets closed once we provide a commit . If u try to close the same cursor with close cursor command later after providing the commit will there be any sql-error.
what is diffrence b/w file-aid tool and file-aid utility???