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 / marekj
I mean you want to fetch only the first row and the select
statement is correct. You have to use "fetch first 1 row
only" eg.
select name
from peoples
where name like 'A%'
fetch first 1 row only;
| Is This Answer Correct ? | 15 Yes | 1 No |
Post New Answer View All Answers
what is the responsibility of the construction superintendent
Mention the location where the output received from explain statement is stored.
What are the contents of dclgen?
What are the benefits of using the db2 database?
Which command is used to connect to a database in DB2 ? Give the Syntax.
Why db2 is called db2?
Explain about cursor stability?
What is the physical storage length of timestamp data type?
What is dclgen (declaration generator)?
How to execute stored procedures?
Explain about rct in db2?
Before you give the explain statement, what are the prerogatives?
How connect db2 database to datastage?
How can you quickly find out the # of rows updated after an update statement?
Define db2 and its databases?