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
- 19225 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 a db2 cursor?
Explain the benefits you can get from mainframe connect?
Explain in detail about buffer manager and its functionalities?
Explain the contents that are a part of dclgen.
What is dbrm? What it contains?
How does db2 sample database connect?
What is scrollable cursor in db2?
What is deadlock in db2?
What is the information associated with sysibm.syslinks table?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
How can you quickly find out the # of rows updated after an update statement?
What is syscat in db2?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
What is the syntax for seeing the columns and data types of a table in the db2 database?
What do you mean by storage group (stogroup)?
