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
- 5518 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
what is the certification that has a good value for a practioner in mainframes but not habving much knowledge on db2 related stuff?
Can you access the DB2 Directory table using SQL?
query to just fetch first matching row and stop execution. once one matching row is found ..no more records should be checked.. if the first record is matching.. the query must stop
When is the authorization check on DB2 objects done - at BIND time or run time?
what is difference between Static call and Dynamic call? How does it function?
What is the maximum No of rows per page?
Once you create a view, where would information about the view be stored?
What is a db2 cursor?
How to take backup of table in db2?
Generally if I want to select the names starting with c I need to use c% But how could I code to select the data which contains % as a part of data.
Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?
when i am trying to update a table having 1000 rows. the program abends.how we will come to know the last successful updated row was. we are not using any commit operations
COBOL 
