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
How to resolve deadlock issue
What is dbrm? When it will be created?
What is the role of union all and union
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
How can we read records for specific member in CL? AND rpg?
How is deadlock resolved?
What is db2 bind process?
What is db2 and what is the use of db2 optimizer?
What is the information associated with sysibm.syslinks table?
What are iseries servers?
Name the lockable units in DB2?
What is the function of logging in the db2 database?
What is an instance in db2?
How do we specify index to include or not during bind process.
List out the buffer pools in db2