You cannot use 'Fetch first 1 row only' in a singleton select i

I am getting a error multiple row fetched while executing a
Cobol-DB2 program.How can I solve it without using a cursor.

Question Posted / anamika

8 Answers
21275 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

Please Help Members By Posting Answers For Below Questions

Is db2 relational database?

1044

I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

2436

What are the 2 sqlcodes that are returned?

1232

What is syscat in db2?

1070

What is image copy in db2?

1070

What is role in db2?

1159

What are the various isolation levels possible?

1177

What is drop table?

1065

What is db2? Explain.

1109

Which are the db2 tools to protect integrity of the database?

1166

How do I import data from excel to db2?

1128

what is the responsibility of the construction superintendent

2209

How do I add a column in db2?

1090

Name the lockable units in DB2?

1187

What is ibm db2 database?

1064