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
- 26794 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 |
My cobol program(not having any sql statements) is calling another cobol program ( having sql statements), what is needed for compilation and run in jcls .
Explain the use of the WHERE clause.
How do you do the EXPLAIN of a dynamic SQL statement?
How to create db2 table in mainframe?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
On the create tablespace, what does the CLOSE parameter do?
Explain the benefits you can get from mainframe connect?
Suppose we have a query for update update table1 set col1 = 'val1' where col2=(select .... from ...) suppose the subquery does not return any record, what will happen to update?
Which isolation level provides highest data integrity?
How to check table size in db2 sap?
how to take the back up of the DB2 table.
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
COBOL 
