select * from orders where odate between '2010-01-01'and '2010-0

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

Question Posted / rajesh_m13

2 Answers
5714 Views
I also Faced
E-Mail Answers

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

What will the FREE command do to a plan?

2 Answers

Can DB2 be accessed by TSO users? If yes, which command is used to invoke DB2?

1 Answers

what's the best lock size that you could use when you create a tablespace?

2 Answers IBM,

What is a DB2 catalog?

2 Answers

EXPLAIN has output with MATCHCOLS = 0. What does it mean?

2 Answers

Which is faster delete or truncate?

0 Answers

What are the two types of logging in the db2 database? Explain them.

0 Answers

What do you do to keep the cursor from closing after a commit?

1 Answers

Where to download IBM DB2 Certification Dumps for the below: C2090-311 : IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1 C2090-312 : IBM DB2 11 DBA for z/OS C2090-313 : DB2 11 Application Developer for z/OS C2090-317 : DB2 11 System Administrator for z/OS C2090-541 : DB2 9.7 DBA for Linux UNIX and Windows C2090-543 : DB2 9.7 Application Development C2090-544 : DB2 9.7 Advanced DBA for LUW C2090-545 : DB2 9.7 SQL Procedure Developer C2090-546 : DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade C2090-610 : DB2 10.1 Fundamentals C2090-611 : DB2 10.1 DBA for Linux, UNIX, and Windows C2090-612 : DB2 10 DBA for z/OS C2090-614 : DB2 10.1 Advanced DBA for Linux UNIX and Windows C2090-615 : DB2 10.5 Fundamentals for LUW C2090-617 : DB2 10 System Administrator for z/OS C2090-730 : DB2 9 Family Fundamentals C2090-733 : DB2 9 Application Developer C2090-735 : DB2 9.5 SQL Procedure Developer C2090-737 : DB2 9 System Administrator for z/OS Exam

1 Answers Mphasis,

What is a db2 collection?

0 Answers

Define db2.

0 Answers

i have cobol+ db2 program but it contains n number of subprograms for this how many dbrm members i need to mention in bind process

2 Answers

For more DB2 Interview Questions Click Here