Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 20639 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
What is consistency token in db2?
What does runstats do in db2?
What is a storage group (stogroup)?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
What is the maximum number of columns in a db2 table?
Which component is responsible for processing sql statements and selecting access paths?
What is a system catalog table in db2?
what are bind concepts in db2 cobol?
Before you give the explain statement, what are the prerogatives?
How to compare data between two tables in db2?
Explain in brief how does db2 determine what lock-size to use?
What is a db2 table?
How do I add a column to a table in db2?
What is a bind in db2?
Mention the different locking levels that are available in db2.
