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
- 5989 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 |
we can code COPY DCLGEN or INCLUDE DCLGEN, At which stage of the precompilation , dclgen get expanded if we write 1) copy 2) include one question about dclgen.. Is it mandatory to use declare table in dclgen.. I think no...but it will be used by the precompiler to validate the table name,column name etc.., can one clear my doubt ..is it necessary to include declare table or not?
How to find the maximum value in a column in the db2 database?
What is db2 bind?
What is an alias and how does it differ from a synonym?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
what is static sql? what is dynamic sql? Give me details
What is a DBRM, PLAN ?
when does the SQL statement gets executed when you use cursor in the application programming ?
What is the SQL query to select, delete and get count of duplicate rows in DB2?
What is a result table?
What is RUNSTATS?
What is COPY PENDING status?
COBOL 
