Kbase P2868: How to make hidden tables visible again in the Data Dictinar
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
18/03/2003 |
|
Status: Unverified
GOAL:
How to make hidden tables visible again in the Data Dictinary on Unix
FACT(s) (Environment):
Sun Solaris SPARC
FACT(s) (Environment):
Progress 8.x
FIX:
On Unix, under Data Dictionary > Schema > Modify Table a toggle can be set to "Yes" to hide a table; it is set to "No" by default.
With the Data Dictionary under Unix, however, there is no toggle that allows you to see what the hidden tables are.
Under Data Dictionary > Schema > Modify Table, the name of a hidden table can still be input at the prompt: the hidden table comes up, and the toggle for hidden can be rest to "No".
This is no use if you don't know what tables are hidden though, or if you want to do this from within a procedure. So the following piece of code will show you what tables are hidden, and it can be adapted to use an ASSIGN or UPDATE if you want to change the status through a procedure:
/* displayhidden.p */
For each _file where _hidden = yes:
disp _file._file-name.
end.
In Character Results, for instance, the maximum number of files in a scrolling list is 512. Using the Data Dictionary > Schema > Modify tables, enough files
have to be hidden so that the 512 file limit will not be exceeded. These files then have to be unhidden.