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

How many types of page locks can be held in db2?

1090

Why db2 is called db2?

1107

What is check constraint in db2?

1164

What is host variable?

1112

Are view updateable?

1092

What is phantom read in db2?

1224

Mention some fields that are a part of sqlca.

1096

How can the duplicate values be eliminated from db2 select?

1160

How to fetch the last row from the table in SQL (db2)?

1697

Is it possible using max on a char column?

1192

What os does db2 run on?

1047

What is the use of db2 optimizer?

1175

Can you tell me how can you find out the # of rows updated after an update statement?

1147

What are the different types of base tables?

1166

What is rebind in db2?

1117