I am using DB2/400 in AS400. I am told as a rule fields which are defined as primary key within a table should not be modifiable. That is if you issue an update statement in which one of the fields which is part of primary key is also getting modified, system should give an error. But when I did this in DB2/400, it went through succesfully.
I would like to mention that ther is no RI with regard to this table.
1) Is it only a principle that primary key should not be changed?
2) If yes how there is no error message?