Hi, You will get -811 SQLCODE if more than one rows will be returned b

What error I will get if my select query gives multiple
row while executing a Cobol-DB2 program.How can I solve it
without using a cursor.

Question Posted / nitin sharma

4 Answers
11672 Views
Cap Gemini, Verizon, I also Faced
E-Mail Answers

Answer Posted / nitin sharma

Hi,

You will get -811 SQLCODE if more than one rows will be
returned by your query.

To avoid this you can also use FETCH FIRST 1 ROWS ONLY in
your query like

SELECT * FROM EMP
FETCH FIRST 1 ROWS ONLY;

Hope this helps.

Nitin

Is This Answer Correct ?

11 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Which components manage deadlocks in db2?

1059

Can there be more than one cursor open for any program?

1161

When the like statement is used?

1220

What is bind in db2?

1031

How connect db2 database to datastage?

1230

What is the use of runstats in db2?

1100

What is syscat in db2?

996

what is the sqlcode -501

13111

How to rename a table in DB2 ?

1084

What are the various isolation levels possible?

1114

What is difference between alias and synonym in db2?

1131

How do I optimize a query in db2?

1093

Mention the definition of cobol in varchar field.

1237

What is commit in db2?

1043

How to view db2 table structure?

1009