Interested to Buy Any Domain ? << Click Here >> for more details...
select * from orders where odate between '2010-01-01'and
'2010-03-31' How do u fetch this into cursor?
- 2 Answers
- 5759 Views
- I also Faced
- E-Mail Answers
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
What is dclgen in db2?
What is precompiler in db2?
How do I add a column to an existing table in db2?
List out the three types of page locks that can be held.
What is the meaning concurrency in the db2 database?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
What is buffer pool in the db2 database?
What is commit in db2?
What is db2 catalog database?
How to fetch the last row from the table in SQL (db2)?
Can you tell me how can you find out the # of rows updated after an update statement?
Define predicate?
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.
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
What is the use of db2?
