When Can you be sure that a query will return only one row?

Answer Posted / shankar

When you use CURSORS in your program.

or

when you use FETCH FIRST (n) ROW ONLY option on your SELECT
statement.

Is This Answer Correct ?    1 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is ibm db2 open source?

584


What does runstats do in db2?

607


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

597


What is a db2 cursor?

622


How to run db2 command in windows?

643






Describe major components of db2?

638


What is load utility in db2?

665


What is the use of dclgen in db2?

588


How to find the number of rows in a db2 table?

644


How and when does the db2 enforces the unique key?

613


What is the cobol picture clause of the db2 data types date, time, timestamp?

614


What is cobol db2?

568


List out the data types available.

700


What is database alias db2?

600


What is a system catalog table in db2?

586