RE: How to change the allow delete status on a PF

Birgitta,
This is not an authority issue.
If you do a DSPFD of a table you will see these attributes:
Allow read operation . . . . . . . . . . . : Yes
Allow write operation . . . . . . . . . . . : Yes
Allow update operation . . . . . . . . . . : ALWUPD *YES
Allow delete operation . . . . . . . . . . : ALWDLT *YES
Record format level check . . . . . . . . . : LVLCHK *YES
BTW, only Allow Write is in SYSTABLES.
If these are set to *NO then only very specific IBM tasks are allowed to perform those operations.
You will see some of these set on a temporal table's history file. Allow write and allow update are not allowed. They still allow you to delete so that you can purge off rows.
To turn these to no:
ALTER TABLE rco ADD VERSIONING USE HISTORY TABLE rco_history;
To turn these back to yes:
Alter table rco Drop versioning;
Again, not a security function.


Rob Berendt