What is sqlcode -811?

Answer Posted / rami reddy

If single select returns more than one row then you get
SQLCODE = -811

Is This Answer Correct ?    38 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many types of page locks can be held in db2?

840


What is sqlca’s maximum length?

925


What is the syntax for FETCH in DB2 ?

953


Mention some fields that are a part of sqlca.

814


Which component is used to execute the sql statements?

876


My sql statement select avg(salary) from emp yields inaccurate results. Why?

882


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.

2547


in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

1874


What is the physical storage length of the data types: date, time, timestamp in the db2 database?

941


What is role in db2?

843


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

865


What is consistency token in db2?

894


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

830


What is the role of the data page in the db2 database?

802


What does sqlcabc has?

828