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

Answers were Sorted based on User's Feedback



how to resolve -811 sqlcode .give clear explaination..

Answer / 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

how to resolve -811 sqlcode .give clear explaination..

Answer / vas

Use Cursor...

Is This Answer Correct ?    0 Yes 0 No

how to resolve -811 sqlcode .give clear explaination..

Answer / alonso

How use cursor for fix it?
Never see it sorry

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More DB2 Interview Questions

Explain the EXPLAIN statement?

1 Answers  


When do you specify the isolation level? How?

1 Answers  


if there is a table with huge number of records and if i want to extract only first 3 records from the table, what query i have to provide to retreive first 3 records

4 Answers   UST,


What is db2 bind?

0 Answers  


How does the processing of a correlated subquery differ from a non correlated subquery?

1 Answers  


How to execute stored procedure in db2 command editor?

0 Answers  


What is difference between isnull and coalesce?

0 Answers  


What are union and union all?

0 Answers  


can any one give the list of some important sql abend codes which r frequently asked in interviews?

2 Answers  


What does this mean ? GRANT BIND,EXECUTE ON PLAN MK2 TO PUBLIC;

4 Answers   Accenture,


What is check constraint. Explain with example.

0 Answers  


what is the differences between spufi and qmf and which is better?

4 Answers   Accenture, Cap Gemini,


Categories