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

What is collection in db2 bind?

991

How is deadlock resolved?

1125

Give the name of some fields form sqlca.

1058

Mention some fields that are a part of sqlca.

1008

What is ibm db2 connect?

975

What are the various isolation levels possible?

1101

Comment whether the cursor is closed during commit or not.

1081

How many databases are there?

1036

What is consistency token in db2?

1114

What are the different types of base tables?

1072

Discuss about db2 bind?

1078

Is ibm db2 free?

994

Can there be more than one cursor open for any program?

1160

How do I optimize a query in db2?

1081

How to find the maximum value in a column in the db2 database?

1061