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
- 19110 Views
- I also Faced
- E-Mail Answers
Answer Posted / anamika
You cannot use 'Fetch first 1 row only' in a singleton
select in COBOL. Instead u can use 'SELECT TOP <colname>'
to get the first row in the result set.
| Is This Answer Correct ? | 0 Yes | 5 No |
Post New Answer View All Answers
Name the various locking levels available?
Mention some fields that are a part of sqlca.
Can you use max on a char column?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
What is scrollable cursor in db2?
How to get the ddl of a table in db2?
Outputs of explain are with matchcols = 0. What does this signify?
Name the lockable units in DB2?
What is dbrm? What it contains? When it will be created?
What is ibm db2 connect?
What is schema in db2?
Explain package in db2 and its advantages?
List down the types of triggers in the db2 database?
What is a trigger in the db2 database?
How do I create a view in db2?
