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

2 Answers
5984 Views
I also Faced
E-Mail Answers

Answer Posted / mahesh

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

Is This Answer Correct ?

2 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Define predicate?

1204

File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

3009

by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

9365

What is syscat in db2?

1072

What is cursor in dbms?

1112

Explain the contention situations caused by locks?

1145

Define sqlca.

1172

What is the latest version of ibm db2?

1337

Why select is not preferred in embedded sql programs?

1351

What is db2 bind?

1131

What is db2 bind process?

1292

What is the syntax for creating a table in the db2 database?

1150

What is ibm db2 connect?

1056

Define db2 and its databases?

1112

What is table space in db2?

1072