I am getting a error multiple row fetched while executing a
Cobol-DB2 program.How can I solve it without using a cursor.
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / nadeem
Select statement fetches only one row from table..make sure
ur program doesn fetch multiple rows..cursor is the only
way to fetch multiple rows to my knowledge..
Is This Answer Correct ? | 5 Yes | 1 No |
Answer / anamika
DB2 doesnt support 'TOP' clause. Please ignore my prev
reply.
Is This Answer Correct ? | 4 Yes | 2 No |
Answer / raja mohan reddy
As of my knowledge,we cannot fetch multiple rows with out
using cursor in cobol db2, Let us see the breif explanation
When you are trying to fetch multiple rows with select
statement using perform loop it gives the result as
fetches the first row while fetching the second row program
will be end with sqlcode.
Here is the only one way to fetch multiple rows from db2
table using cobol. Please follw the following steps.
1.Declare a cursor ( we have to code SELECT statement with
our criteria)
2.Open the cursor
3.fetch the rows using cursor
4.Close the cursor
Please Let me know if you find any mis stated information
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / anju
To my knowledge, we can use fetch clause in a singleton
select inside COBOL.
Is This Answer Correct ? | 0 Yes | 1 No |
Answer / nk
Try using one of the group functions, for example, MAX or
SUM.
Is This Answer Correct ? | 2 Yes | 4 No |
Answer / ram.g
Pass the unique key to fetch the row from the table
Is This Answer Correct ? | 0 Yes | 3 No |
Answer / 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 |
Which command is used to remove all rows from a table?
When Can you be sure that a query will return only one row?
In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?
What is isolation level in db2?
What is package in db2 mainframe?
1) I have 3 programs : PGMA, PGMB, PGMC. PGMA calls PGMB and PGMB calls PGMC. I have to do inserts, updates in all the 3 pgms. 2) Say PGMC has done its work successfully and returned to PGMB 3) PGMB had an SQL error while doing some update 4) PGMA has already done some updates before calling PGMB all are running under the same CICS region. What will happen if I issue SYNCPOINT ROLLBACK in PGMB when it abends ? Does all the changes in PGMA,B,C rollback ? (because all the pgms belong to same task).
What information is contained in a SYSCOPY entry?
how can we retrieve the 100 records of the file ?
There is a 5000 EMP in company.how we find out the 5th highest getting salary employee outof 5000 employes........
Why do we bind in db2?
How are write I/Os from the buffer pool executed?
What is DYNSLT keyword? How do you perform selection using DYNSLT