DB2 doesnt support 'TOP' clause. Please ignore my prev reply.

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
21041 Views
I also Faced
E-Mail Answers

Answer Posted / anamika

DB2 doesnt support 'TOP' clause. Please ignore my prev
reply.

Is This Answer Correct ?

4 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Can we update view in db2?

1003

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

1045

Mention the downsides of page level lock.

1161

What is reorg?

1161

Mention the definition of cobol in varchar field.

1250

What is db2 look?

1025

Explain correlated sub-queries.

1033

by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

9211

what is db2 restart?

2162

What is an instance in db2?

1034

Where do you specify them?

1281

What is iseries database?

1048

What is the use of with ur in db2?

1058

Why cursor is used in db2?

1036

What is syscat in db2?

1010