Interested to Buy Any Domain ? << Click Here >> for more details...
can we update the table by using cursors can anyone post
the query?
- 5 Answers
- 10860 Views
- DELL, HCL, I also Faced
- E-Mail Answers
Answer Posted / siri
suppose we want update ename in emp table using cursor....
declare crsorname cursor for
select * from emp
where dept='d005'
for update of ename....
upate emp
set ename=:ename
where current of cursor
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
What is the maximum size of varchar data type in db2?
When do you specify the isolation level?
Which isolation level provides maximum concurrency?
what is the responsibility of the construction superintendent
Describe major components of db2?
Mention the definition of cobol in varchar field.
what is diffrence b/w file-aid tool and file-aid utility???
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
What language is db2 written in?
Explain packages.
What is table space in db2?
Is db2 relational database?
What does sqlcabc has?
What is concurrency?
