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
What are db2 tables?
What is difference between isnull and coalesce?
What is explain plan in db2?
How does a cursor work?
What is the meaning concurrency in the db2 database?
Which command is used to connect to a database in DB2 ? Give the Syntax.
What is dbrm in db2 database?
What is the use of db2?
What's The Percentage Free Space ?
What is dbrm? What it contains?
Discuss about db2 bind?
How do I delete a table in db2?
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.
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
What is the difference between plan and package in db2?