Interested to Buy Any Domain ? << Click Here >> for more details...
Is it possible to update a primary key value? If not, what
is the error code given? If yes, can more than 1 primary
key column be updated at a time?
- 8 Answers
- 26514 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / guest
Primary key value can be updated as well provided the value
you update it with identifies it uniquely.
| Is This Answer Correct ? | 28 Yes | 4 No |
Answer / keshireddy
further, multiple primary keys can be updated at time. Only
condition is that value should be unquie. else sql code -803
| Is This Answer Correct ? | 18 Yes | 0 No |
Answer / guest
Ans 3 is correct. If the key already present, while
updating it will show the sql code as = -803.
| Is This Answer Correct ? | 12 Yes | 1 No |
Answer / guest
also remember, you cannot update a primary key when it has
matching foreign key values.
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / haribabu
yes, it is possible, move 'value' to ws-eno. Here ws-eno is
primary-key.
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / deepak
First u will need to drop the index and then make the
required changes to PK and later again create the
index,Make sure u have all the conditing to for PK fine.
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / priya
If a primary key column cannot be updated, what is the
error code given when an attempt is made to update it
through a SQL query in a COBOL program?
| Is This Answer Correct ? | 3 Yes | 5 No |
What is deadlock in db2?
What is the function of buffer manager?
What does the RUNSTATS Utility do?
what are the max. & min. no. of partitions allowed in a partition tablespace?
How many buffer pools are available in db2?
What is the COBOL picture clause for a DB2 column defined as DECIMAL(11,2)?
How many Buffer pools are there in DB2 and what are they?
what is a corelated subquerry?
What are common abends
What is the SQL query to select, delete and get count of duplicate rows in DB2?
what is main use of table space and index object? please its urgent
5 Answers CA, Cap Gemini, CGI, CTS, EDS, HTC, IBM, Satyam, Syntel, TCS, Wipro,
How can you do the explain of a dynamic sql statement?
COBOL 
