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

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

Question Posted / mahesh

Answer Posted / mahesh

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

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How many types of page locks can be held in db2?

1042

Where do you specify them?

1281

How many databases can be created inside an instance in db2 ?

1035

How does db2 sample database connect?

1030

How to restart a DB2 program?

1902

What are the different types of base tables?

1094

What is the role of the data page in the db2 database?

1028

What is cursor with hold option in db2?

1073

Explain the contents that are a part of dclgen.

1091

What is dbrm?

1105

What action db2 takes when a program aborts in the middle of a transaction?

1156

What is db2 connect?

1069

Explain about mirror activator disk mirroring?

1010

What is the role of schema in the db2 database?

1275

How can the duplicate values be eliminated from db2 select?

1106