I am getting a error multiple row fetched while executing a
Cobol-DB2 program.How can I solve it without using a cursor.

Answer Posted / anamika

You cannot use 'Fetch first 1 row only' in a singleton
select in COBOL. Instead u can use 'SELECT TOP <colname>'
to get the first row in the result set.

Is This Answer Correct ?    0 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What kind of database is db2?

569


What is runstats utility in db2?

569


Give a brief description of db2 isolation levels?

599


How would the varchar column remarks defined?

635


Which isolation level provides highest data integrity?

595






What is the usage of open cursor command?

599


What is a db2 collection?

603


On which levels locks can be applied?

655


How to find the number of rows in db2 tables?

614


What is netezza database?

573


Can we update view in db2?

558


What are the uses of db2 optimizer?

815


What are iseries servers?

566


What is the meaning concurrency in the db2 database?

630


What are the benefits of using the db2 database?

658