RETRIEVING MORE THAN ONE ROW BY USING SELECT STATEMENT THEN AN ABEND WILL

how to resolve -811 error. give clear explination

Question Posted / srinvasa yadav

Answer Posted / srinvasa yadav

RETRIEVING MORE THAN ONE ROW BY USING SELECT STATEMENT THEN
AN ABEND WILL OCCUR I.E -811.
RESOLVE: DELCARE CURSOR

Is This Answer Correct ?

3 Yes

1 No

Please Help Members By Posting Answers For Below Questions

what is db2 restart?

2101

Is it possible to create an Instance in DB2 using DB2 Control Center ?

1041

How can the duplicate values be eliminated from db2 select?

1039

Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

1003

What is netezza database?

959

How to create backup table in db2?

1041

How do I add a column in db2?

997

What do you mean by cursor?

942

How is a typical db2 batch pgm executed?

1109

Is db2 a mainframe?

968

before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?

2123

Why do we bind in db2?

1140

What is the syntax for creating a table in the db2 database?

1058

What is dbrm? What it contains? When it will be created?

992

What is the use of db2 optimizer?

1036