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 type of database is db2?

905

What is runstats db2?

961

What is the maximum number of columns in a db2 table?

1209

How is deadlock resolved?

1080

what is utility for parm lib

2306

What is collection in db2 bind?

955

Explain about rct in db2?

1043

How to compare data between two tables in db2?

1027

What is isolation level in db2?

938

before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?

2122

What is dpf in db2?

1047

What is netezza database?

956

How to check table size in db2 sap?

975

Explain the contents that are a part of dclgen.

1031

How do I create a view in db2?

969