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

Which component is responsible for db2 startup and shutdown?

1033

run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...

4309

Define sqlca.

1106

List out the three types of page locks that can be held.

1149

How would the varchar column remarks defined?

1086

What is universal database?

1067

How can you classify the locks in db2?

1089

What is concurrency?

1231

What is dbrm? What it contains?

1163

can we view the access paths created by dbrm ? how ? thx

7091

How to execute stored procedure in db2 command editor?

1047

How can you count the number of rows from a table tab?

1089

How would you find out the total number of rows in a db2 table?

1050

How connect db2 database to datastage?

1237

What is the information associated with sysibm.syslinks table?

1122