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

How many types of page locks can be held in db2?

1028

What are union and union all?

974

What is db2? Explain.

1029

Can we insert update delete in view?

956

Mention the different locking levels that are available in db2.

1125

Explain about mirror activator disk mirroring?

998

Is db2 a mainframe?

1036

What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

1261

What is the difference between db2 and oracle?

1112

What are host variables in db2?

1038

Which isolation level provides maximum concurrency?

1148

What is a db2 package?

1041

Can one database have multiple instances?

1040

What is rebind in db2?

1045

What is phantom read in db2?

1145