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 -803 sql code in DB2?

Answer Posted / venkata sastry

The SQL - 803 error occurs on the violation of a UNIQUE
constraint. Update the record if it already exists rather
inserting new one.

Is This Answer Correct ?    15 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain how can you do the explain of a dynamic sql statement?

1131


Which command is used to remove all rows from a table?

1121


What is db2 instance?

1110


Explain the contention situations caused by locks?

1081


What are the rules for db2 programming?

1102


Define data page.

1077


What db2 400?

1207


Explain the contents that are a part of dclgen.

1097


What is commit in db2?

1065


Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

1069


what is the sqlcode -501

13173


have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.

1742


What is temporal table in db2?

1048


Explain the function done by data manager?

1286


How do you stop a db2 database in linux?

1021