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

Why db2 is called db2?

970

When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

3520

Which command is used to remove all rows from a table?

1038

What is buffer pool and list some of them?

981

What is blu acceleration in db2?

1014

How to execute stored procedures?

1063

What is the result of open cursor statement?

1028

How do you simulate the explain of an embedded sql statement in spufi/qmf?

1025

What is a page in db2?

980

What is load replace in db2?

936

What are the 2 sqlcodes that are returned?

1129

What are foreign keys in db2?

1034

How do you eliminate duplicate values in db2?

1108

How can the duplicate values be eliminated from db2 select?

1040

What is clone table?

995