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
- 27106 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 |
PLAN IS EXECUTABLE AND PACKAGE IS NOT EXECUTABLE . THEN WHAT IS THE USE OF PACKAGE?
2 Answers Tech Mahindra, Wipro,
how we will do null data selection in cobol-db2 program
Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?
what are the bind parameters?
what is the certification that has a good value for a practioner in mainframes but not habving much knowledge on db2 related stuff?
Is the primary key a clustered index?
What is load utility in db2?
How do you concatenate the firstname and lastname from emp table to give a complete name?
What is dbrm? What it contains? When it will be created?
database DSNDB01 means a.db2 catalog b.db2 directory c.BSDS d.active logs answer with reason please
How do you pull up a query which was previously saved in qmf?
What is error -818 in db2. where can you find the timestamp of the DBRM and the source code.( precompile puts the timestamp on dbrm and source code correct?)
COBOL 
