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

How to rename a table in DB2 ?

1088

Explain about rct.

1089

What is the result of open cursor statement?

1083

What is buffer pool and list some of them?

1028

What is commit in db2?

1058

What is cloudant database?

1101

Why do we use cursor?

1105

What is sqlca?

1079

How can you do the explain of a dynamic sql statement?

1069

i want to maintain uniqueness on pdf without make lf??????????

2158

In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

1046

What is null indicator in db2?

1113

How to find the maximum value in a column in the db2 database?

1084

What is the physical storage length of time data type?

1129

What is the maximum length of sqlca?

1529