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
9379 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

What is a db2 schema?

1233

What is dclgen in db2?

1149

in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

2098

What is access path in db2?

986

Explain correlated sub-queries.

1033

What is consistency token in db2?

1144

What is buffer pool?

1107

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

1108

What is the default page size of buffer pools?

1122

What is a collection in db2?

1036

Name the lockable units in DB2?

1128

How can we read records for specific member in CL? AND rpg?

700

How to resolve deadlock issue

20133

Can you tell me how can you find out the # of rows updated after an update statement?

1101

What is the difference between plan and package in db2?

1113