Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 8 Answers
- 32893 Views
- CGI, Wipro, I also Faced
- E-Mail Answers
Answer Posted / ns
There 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.
| Is This Answer Correct ? | 28 Yes | 6 No |
Post New Answer View All Answers
Can we delete records from view?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
Define sqlca.
what is utility for parm lib
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
What is a Foreign Key?
Explain how can you do the explain of a dynamic sql statement?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
Can one database have multiple instances?
Mention data types used in db2 ?
What is the use of commit in db2?
What is precompiler in db2?
What are the 2 sqlcodes that are returned?
Explain the contents that are a part of dclgen.
