how to resolve -811

Answers were Sorted based on User's Feedback



how to resolve -811..

Answer / srini

Declare cursor instead of singleton select,as the query you
are running has multiple records.

Is This Answer Correct ?    3 Yes 0 No

how to resolve -811..

Answer / vamsi

use perform statement

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More DB2 Interview Questions

how to check the table is empty or not?

3 Answers   IBM,


quary for 1> fetch last record 2> fetch in reverse order 3> fetch last 5 row 4> fetch second last record (their is no primary key) i think concept of count can be use for this in 4th

5 Answers  


what is main use of table space and index object? please its urgent

5 Answers   CA, Cap Gemini, CGI, CTS, EDS, HTC, IBM, Satyam, Syntel, TCS, Wipro,


What is the difference between IN subselects and EXISTS subselect?

1 Answers   HCL, PreVator, TCS,


How can you find out which query is taking lot of time to execute in cobol-db2 program ?

1 Answers   Danske,






What is the use of db2?

0 Answers  


could you give me an example how, where i code CHECKPOINT and restart...I need and example....thanks..

5 Answers  


what is the sqlcode -501

5 Answers   IBM, Polaris, Zeus,


What are bind parameters in db2?

0 Answers  


how to fetch multiple records without using cursor

14 Answers   HCL,


What is index in db2?

1 Answers  


What is the physical storage length of the data types date, time, and timestamp?

0 Answers  


Categories