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

What are db2 tables?

785


What is difference between isnull and coalesce?

725


What is explain plan in db2?

712


How does a cursor work?

660


What is the meaning concurrency in the db2 database?

769






Which command is used to connect to a database in DB2 ? Give the Syntax.

719


What is dbrm in db2 database?

699


What is the use of db2?

711


What's The Percentage Free Space ?

894


What is dbrm? What it contains?

827


Discuss about db2 bind?

789


How do I delete a table in db2?

769


I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.

2888


If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

1712


What is the difference between plan and package in db2?

714