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

Can we delete records from view?

915

What is netezza database?

959

Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.

2667

What is database alias db2?

1066

What is explain plan in db2?

942

Discuss about db2 bind?

1049

How do you concatenate the firstname and lastname from emp table to give a complete name?

1012

What is the syntax for FETCH in DB2 ?

1137

What are iseries servers?

1009

What is host variable in db2 cobol?

1028

is it compulsory commitment control in journal?

2415

What is temporal table in db2?

988

Is db2 relational database?

915

How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

2167

What is a db2 cursor?

1005