how to resolve -811

Question Posted / guest

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

More DB2 Interview Questions

Can we use select * statement in cobol program without giving field names ???

How do you eliminate duplicate values in db2?

Explain what a plan is?

What is a view? Why use it?

What is a host variable?

What is difference between isnull and coalesce?

What is ibm db2 connect?

What is cursor?

Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?

List some fields from sqlca?

How many buffer pools are available in db2?

How many buffer pools are there in DB2?

For more DB2 Interview Questions Click Here