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 to take backup of table in db2?

806

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

841

What does db2 stand for?

763

What is the use of predicate?

784

Why select is not preferred in embedded sql programs?

934

What is lock escalation in db2?

774

How do I create a view in db2?

785

How can record locking be achieved in those DB2 versions which do not support it?

830

What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

953

Explain the contents that are a part of dclgen.

864

Outputs of explain are with matchcols = 0. What does this signify?

826

How to check table size in db2 sap?

776

Give a brief description of db2 isolation levels?

783

Why do we bind in db2?

874

What is null in db2?

753