1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

select * from orders where odate between '2010-01-01'and
'2010-03-31' How do u fetch this into cursor?

Question Posted / rajesh_m13

Answers were Sorted based on User's Feedback



select * from orders where odate between '2010-01-01'and '2010-03-31' How do u ..

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

select * from orders where odate between '2010-01-01'and '2010-03-31' How do u ..

Answer / mahesh

don't use * in select statement while retrieving data from
database

Is This Answer Correct ?    2 Yes 1 No

Post New Answer

More DB2 Interview Questions

When do you use the IMAGECOPY?

4 Answers  

What is iseries database?

0 Answers  

Explain the EXPLAIN statement?

1 Answers  

Suppose the outcome of executing a query results in a row having null. Based on the answer how you use it? Its declaration and inclusion?

2 Answers   Verizon,

What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

0 Answers   MCN Solutions,




Explain an outer join?

1 Answers  

What is syscat in db2?

0 Answers  

What is sqlca’s maximum length?

0 Answers  

What is the difference between drop table and delete table?

0 Answers  

My cobol program(not having any sql statements) is calling another cobol program ( having sql statements), what is needed for compilation and run in jcls .

3 Answers   Cap Gemini, RBS,

How to insert more than one record using insert?

7 Answers   Atos Origin, IBM,

What is cursor?

2 Answers  

For more DB2 Interview Questions Click Here
Categories