select * from orders where odate between '2010-01-01'and
'2010-03-31' How do u fetch this into cursor?
- 2 Answers
- 6089 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 a DB2 access path?
Is db2 free?
I am getting a error multiple row fetched while executing a Cobol-DB2 program.How can I solve it without using a cursor.
When the like statement is used?
What is a db2 schema?
When would you prefer to use VARCHAR?
What is the difference between bind and rebind in db2?
how do you resolve -818 error in db2. where we have to see time stamp token. i said by seeing in load module and plan .is it correct or not. give clear explination for how to see time stamp token
If I have a view which is a join of two or more tables, can this view be updatable?
how many partitions are possible in partitioned tablespace? dont say 1-64. a)240 b)256 c)512 d)none
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
Can we use select * statement in cobol program without giving field names ???
COBOL 
