I am getting a error multiple row fetched while executing a
Cobol-DB2 program.How can I solve it without using a cursor.
- 8 Answers
- 17915 Views
- I also Faced
- E-Mail Answers
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
can we view the access paths created by dbrm ? how ? thx
What are foreign keys in db2?
Outputs of explain are with matchcols = 0. What does this signify?
What is image copy in db2?
What is an instance in db2?
What is db2 stogroup?
What are types of indexes?
What is the use of db2?
How can we retrieve the total number of records in RPG & CLLE?
What is the usage of open cursor command?
What is difference between rollback and commit?
what is the responsibility of the construction superintendent
Which isolation level provides highest data integrity?
What is ibm db2 used for?
What is syscat in db2?
