REASON: BY USING SELECT QUERY,WE CAN ACCESS MULTIPLE ROWS THEN -811 ERROR O

how to resolve -811 error. give clear explination

Question Posted / venkat

Answer Posted / venkat

REASON: BY USING SELECT QUERY,WE CAN ACCESS MULTIPLE ROWS THEN -811 ERROR OCCURS

SOLUTION : BY USING CURSORS, WE CAN ACCESS MULTIPLE ROWS

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the max length of sqlca?

958

How can the duplicate values be eliminated from db2 select?

847

Mention a credible reason why select* is never given preference in an sql program that has been embedded.

926

Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

844

What is the use of with ur in db2?

788

Mention some fields that are a part of sqlca.

775

what is the responsibility of the construction superintendent

1868

Explain about cursor stability?

778

Explain what are the various isolation levels possible?

785

What is sqlca?

808

What is the maximum number of columns in a db2 table?

976

What are concurrency issues?

800

What is db2 instance?

790

Which isolation level provides maximum concurrency?

884

What are the 2 sqlcodes that are returned?

851