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

Can you use max on a char column?

1097

My sql statement select avg(salary) from emp yields inaccurate results. Why?

1095

What do you mean by cursor?

989

before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?

2182

What is null indicator in db2?

1114

What is image copy in db2?

1021

SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

11676

What is a bind card?

1218

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

1044

What is host variable?

1060

What is collection in db2 bind?

1017

Explain about rct.

1090

What is the information associated with sysibm.syslinks table?

1125

How do I connect my db2 database to ibm?

1051

How do I change the column size in db2?

1157