Cursors can be declared in both working-storage & procedure
division, Agreed.
But is there any difference? If could you please suggest
what is the difference.
TIA
Submitted by: AdministratorThere is no difference. But it is always better to declare
Cursor in Working-Storage Section because you will not code
Open Cursor before Declare Cursor by mistake. It is just a
standard to declare Cursor in WSS. As best practice to
avoid oversight.
Submitted by: Administrator
Cursor in Working-Storage Section because you will not code
Open Cursor before Declare Cursor by mistake. It is just a
standard to declare Cursor in WSS. As best practice to
avoid oversight.
Submitted by: Administrator
Read Online IBM DB2 Job Interview Questions And Answers
Top IBM DB2 Questions
☺ | what are the bind parameters IBM DB2? |
☺ | What is sqlcode -811? |
☺ | What is sqlcode -922 ? |
☺ | Cursors can be declared in both working-storage & procedure |
☺ | Can you have more than one cursor open at any one time in a program ? |
Top Databases Programming Categories
☺ | RDBMS Interview Questions. |
☺ | SQL Interview Questions. |
☺ | SSRS Interview Questions. |
☺ | Database Administrator (DBA) Interview Questions. |
☺ | Sybase Interview Questions. |