Sign Up Login


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

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?

Question Posted / shefali799

Answers were Sorted based on User's Feedback



Is it possible to update a primary key value? If not, what is the error code given? If yes, can mo..

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

Is it possible to update a primary key value? If not, what is the error code given? If yes, can mo..

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

Is it possible to update a primary key value? If not, what is the error code given? If yes, can mo..

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

Is it possible to update a primary key value? If not, what is the error code given? If yes, can mo..

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

Is it possible to update a primary key value? If not, what is the error code given? If yes, can mo..

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

Is it possible to update a primary key value? If not, what is the error code given? If yes, can mo..

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

Is it possible to update a primary key value? If not, what is the error code given? If yes, can mo..

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

Is it possible to update a primary key value? If not, what is the error code given? If yes, can mo..

Answer / sujeesh

Primary key column cannot be updated,because it is used as
the key field to find out a row uniquely.

Is This Answer Correct ?    17 Yes 22 No

Post New Answer

More DB2 Interview Questions

COBOL PRECOMPILER ERROR: "XXXXXX" (TABLE) PREVIOUSLY DECLARED OR REFERENCED DCLGEN VARIABLES GETS IMPORTED TWICE FOR ONLY ONE EXEC SQL STATEMENT. WHAT COULD BE THE PROBLEM?

1 Answers  

What is isolation level?

4 Answers  

How to run db2 command in windows?

0 Answers  

what is consistency token

3 Answers  

what is difference between random and sequence file access

1 Answers   Syntel,

What is load replace in db2?

0 Answers  

How many clustering indexes can be defined for a table?

2 Answers  

What is the difference between cursor and select statement?

0 Answers  

What is dbrm in db2 database?

0 Answers  

What is a DBRM, PLAN ?

3 Answers  

What is runstats and reorg in db2?

0 Answers  

Can you use a select query in a loop to fetch multiple rows? If so what is the advantage of using a cursor?

2 Answers   L&T, UST,

For more DB2 Interview Questions Click Here
Categories