What error I will get if my select query gives multiple
row while executing a Cobol-DB2 program.How can I solve it
without using a cursor.

Answer Posted / dedu

-811 ERROR CODE

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What happens in bind step in a db2 program?

568


I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

1938


Which isolation level provides maximum concurrency?

666


Give a brief description of db2 isolation levels?

601


Why do we bind in db2?

631






by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

7512


Mention the location where the output received from explain statement is stored.

628


What is buffer pool in the db2 database?

616


How can we retrieve the total number of records in RPG & CLLE?

194


What is cascading rollback?

623


What is dclgen in db2?

678


I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.

2757


How to find schema of a table in db2?

570


What is performance tuning db2?

619


What is the result of open cursor statement?

638