select * from orders where odate between '2010-01-01'and
'2010-03-31' How do u fetch this into cursor?
Answer Posted / muneer
Declare orders_cur cursor
for
select * from orders where odate between '2010-01-01'and
'2010-03-31'.
Open orders_cur
fetch orders_cur....
Hi friends i think that will the procedure ...if any mistake
suggest me
Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
What is the use of dclgen in db2?
Explain the function of data manager.
How do I copy a table in db2?
What is commit in db2?
What is a bind card?
How can you classify the locks in db2?
What does db2 blu stand for?
What is a trigger in the db2 database?
What is bind plan?
What is the clustering index in the db2 database?
What is dclgen (declaration generator)?
Who uses db2?
How is the value function used?
What is a db2 tablespace?