Kbase P114659: VST tables are dumped when using PRODICT\DUMP_DF.R
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/30/2006 |
|
Status: Unverified
SYMPTOM(s):
Dumping database via the PRODICT\DUMP_DF.R script
VST tables are also included in the database definitions (.DF) file
VST tables show in the .DF file as follows:
ADD TABLE "_MyConnection"
AREA "Schema Area"
FROZEN
VST tables were not included in previous .DF files
CAUSE:
The Hidden field for each VST table has been set to No in _file. VST tables are Frozen and Hidden by default and therefore do not normally appear in a .DF file. This can only be changed via user-interaction (by manually unfreezing the table, setting Hidden to No and then re-freezing the table again) or by running a 4GL script against the database that does the same thing.
VST tables (when dumped specifically) would appear as:
ADD TABLE "_MyConnection"
AREA "Schema Area"
FROZEN
HIDDEN
FIX:
Option #1
Via Data Administration:
1) Select Utilities> Freeze/Unfreeze
2) Check the Show Hidden box
3) Double-click on the VST to be changed
4) Uncheck the Frozen box > OK
5) Select Tools > Data Dictionary
6) Select View > Show Hidden
7) Double-click on the VST to be changed
8) Check the Hidden box > OK
9) Commit changes
10) Close Data Dictionary
11) Select Utilities> Freeze/Unfreeze
12) Check the Show Hidden box
13) Double-click on the VST to be changed
14) Check the Frozen box > OK
Option #2
Via 4GL:
1) Set the FROZEN field in _file table to NO for each VST table
2 Set the HIDDEN field in _file table to YES for each VST table
3) Set the FROZEN field in _file table to YES for each VST table