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
- 20952 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 cascading rollback?
What is bind plan?
Which command is used to remove all rows from a table?
can all users have the privilage to use the sql statement select * (dml)?
How would you find out the total number of rows in a db2 table?
Can you tell me how can you find out the # of rows updated after an update statement?
Who uses db2?
Explain in brief how does db2 determine what lock-size to use?
What does db2 blu stand for?
How do I add a column in db2?
Define predicate?
What is the syntax for creating a table in the db2 database?
When do you specify the isolation level?
What is table space in db2?
List out the three types of page locks that can be held.
