When you use CURSORS in your program. or when you use FETCH FIRST (n)

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

Question Posted / shankar

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

Please Help Members By Posting Answers For Below Questions

Which components manage deadlocks in db2?

615

What is copy pending and check pending in db2?

578

Explain the function of data manager.

632

What is ibm db2 used for?

601

Differentiate between cs and rr isolation levels? Where do you specify them?

587

What is lock escalation in db2?

574

can all users have the privilage to use the sql statement select * (dml)?

642

What action db2 takes when a program aborts in the middle of a transaction?

659

What is ibm db2 connect?

573

How do I add a column to an existing table in db2?

592

Is ibm db2 open source?

586

How can you count the number of rows from a table tab?

637

What is performance tuning db2?

620

List out the three types of page locks that can be held.

689

What is ibm db2 database?

538