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

  1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

how to resolve -811 sqlcode .give clear explaination

Question Posted / guest

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

Q1. How will you use two different DB2 qualifiers in a single COBOL program? Suppose we have 2 tables EMP1 and EMP2 with same structure defined in two different DB2 qualifiers QUAL1.EMP1 and QUAL2.EMP2 now during first 15 days we want to use QUAL1.EMP1 and rest of the days QUAL2.EMP2  how will we do this.  We can create a single program and a single load for this program. 

2 Answers   RBS,

What are the abend codes occour in ur latest PROJECT in DB2

2 Answers   Cap Gemini,

which authority can be granted to group of users using the GRANT stmt? A) SYSCTRL B) SYSADM C) DBCTRL D) DB ADM

3 Answers   Accenture,

What should be specified along with a cursor in order to continue updating process after commit?

1 Answers   IBM,

what is the difference between join and union?

4 Answers   IBM,

In db2, how do you insert multiple rows in 1 query using a.) Cursors, b.) Normal query?? Give syntax for both.

5 Answers   CTS,

Name the lockable units in DB2?

0 Answers  

i hav created a program and moved to production but failed to create the table which is been used in the program. the program shows error as soon as it is moved or installed in production or shows error during its runtime. what is the sqlcode for this error

3 Answers   UST,

What does an outer join do?

1 Answers   CTS,

What are the two types of logging in the db2 database? Explain them.

0 Answers  

What is the difference between dbm cfg and db cfg file in db2 ?

0 Answers   MCN Solutions,

List some fields from sqlca?

0 Answers  

For more DB2 Interview Questions Click Here
Categories