Kbase P21262: Error 6547 unfreezing a table
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
17/02/2004 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.x
SYMPTOM(s):
Error 6547 unfreezing a table
Table <table name> and its indexes can be modified or dropped only by SQL92. (6547)
Table sysattachbls and its indexes can be modified or dropped only by SQL92. (6547)
Updating _file fields
Using
"FOR EACH _file WHERE _file-number > 0:
ASSIGN _frozen = no.
END."
Using a 4GL client
CAUSE:
Sysattachbls table is the a internal table that is part of the SQL-92. Tables and indexes can be modified or dropped only by SQL92 client.
SQL-92 tables have file numbers with values 30,000 or more.
FIX:
Add " _file-number < 30000" condition to the query.