Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

how to resolve -811 sqlcode .give clear explaination

Answer Posted / sesha

-811 results when
1)Execution of an embedded SELECT statement has resulted in
a result table containing more than one row.
2)Alternatively, a subquery contained in a basic predicate
has produced more than one value.

Solution is:
Examine the syntax of the statement to ensure that it
contains the proper condition specifications. If it does,
there may be a problem with the data that is causing more
than one row or value to be returned when you do not expect
it.
You can use cursor to overcome this problem.

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How is the value function used?

1207


What is host variable in db2 cobol?

1133


What is rebind in db2?

1117


What is coalesce in db2?

1183


How to restart a DB2 program?

1954


Why do chiropractors use drop table?

1162


What is the physical storage length of date data type?

1304


What is role in db2?

1159


What is schema in db2?

1081


Which isolation level provides maximum concurrency?

1203


define clustering index.

1070


What is with ur in db2?

1384


How to access db2 tables in mainframe?

1100


What is difference between isnull and coalesce?

1106


What type of database is db2?

1018