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

4 Answers
9529 Views
IBM, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE

2116

What are catalog tables in db2?

1104

What db2 400?

1248

What is the latest version of ibm db2?

1331

How do I optimize a query in db2?

1144

What type of database is db2?

1014

Define check constraint.

1125

How to retrieve rows from a db2 table in embedded sql?

1438

How to create db2 table in mainframe?

1213

What is phantom read in db2?

1220

What is dbrm? What it contains?

1211

What is node in db2?

1097

How will you return the number of records in table?

986

Which components manage deadlocks in db2?

1117

How can tablespace be moved to another dasd volume that is allocated for that tablespace?

1287