How to change the Freeze / Unfreeze status of all tables in a database using the progress editor?
What do you mean by Freeze/Unfreeze?
So far as I know the only way to do it is via proutil
"Freezing/Unfreezing" applies to tables. It means changing the value of _file._frozen. When an _file record is frozen, its schema definition can't be altered.
There are two ways. The first, which I believe is one table at a time, is in the Data Dictionary (Utilities | Freeze/Unfreeze):
Code:
Database Schema Admin DataServer Utilities PRO/SQL Tools
┌────────────────────────────────────┐
│ Editor for Parameter Files... │
│ Quoter Functions -> │
│ Generate Include Files -> │
│ ────────────────────────────────── │
┌──────│ Edit OpenEdge Auto-Connect List... │
│ │ Freeze/Unfreeze... │
│ You m│ Index Deactivation... │
│ your │ ────────────────────────────────── │
│ │ Information... │
└──────└────────────────────────────────────┘
The second is programmatically, which can be done on all application tables at once:
Code:
for each dictdb._file exclusive-lock where _file._tbl-type = 't':
_file._frozen = no. // unfreeze
end.
Obviously, your account must have write privilege ("can-write") on _file to do that.
As far as I'm aware it can't be done via proutil. If I'm wrong Tom, can you post the syntax?