select * from orders where odate between '2010-01-01'and
'2010-03-31' How do u fetch this into cursor?
- 2 Answers
- 4702 Views
- I also Faced
- E-Mail Answers
Answer Posted / mahesh
don't use * in select statement while retrieving data from
database
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
what is db2 restart?
How do I copy a table in db2?
Name the lockable units in DB2?
How would you find out the total number of rows in a db2 table?
How do we specify index to include or not during bind process.
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
What is dbrm? When it will be created?
What is bufferpool in db2?
What action db2 takes when a program aborts in the middle of a transaction?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
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.
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
What is a db2 cursor?
What is commit in db2?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
