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
20981 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

Explain db2.

1022

What is the use of db2?

1047

What is the default page size of buffer pools?

1120

What is the meaning concurrency in the db2 database?

1108

How do I optimize a query in db2?

1095

What is the difference between bind and rebind in db2?

1444

How do I add a column to a table in db2?

1098

How to run db2 command in windows?

1186

B37 abend during spufi?

1450

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

1120

What is a Foreign Key?

1091

Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference

1427

Explain about cursor stability?

1040

What is copy pending status in db2?

1117

Explain in brief how does db2 determine what lock-size to use?

1034