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 is a db2 collection?
How to execute stored procedure in db2 command editor?
What is db2 instance?
How do you find the maximum value in a column in db2?
What is role in db2?
How to view db2 table structure?
What are the contents of dclgen?
Explain the function of data manager.
What is db2 and what is the use of db2 optimizer?
What does sqlcabc has?
What is the physical storage length of date data type?
Name the various locking levels available?
Define predicate?
What is explain in db2?
How can deadlocks be resolved?