Kbase P48012: How to dump and load an SQL-89 View File's Content.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
03/04/2009 |
|
Status: Verified
GOAL:
How to dump and load an SQL-89 View File's Content.
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
FIX:
SQL-89 views are not dumped with the same process used to dump standard tables. To dump / load SQL-89 views follow the steps below.
DUMPING SQL View File's Content:
1. Connect to the database containing the view to be dumped.
2. Access the Data Dictionary / Data Administration tool from the Client the
session.
3. Chose Admin/Dump Data and Definitions/Views. Progress prompts for the file name (source), then for the file to which file contents is to be dumped. The default name is _view.d.
4. Specify the filename or accept the default. After dumping the view file contents to the specified file. Progress displays a status message and prompts for a continue.
5. Choose Ok to return to the Data Administration or Data Dictionary main window.
Loading SQL View File Content:
1. Access the Data Dictionary / Data Administration tool from a Client session and select the database that the Views are to be loaded into. Access the Data Dictionary / Data Administration tool from the Client session.
2. Chose Admin/Load Data and Definitions/SQL Views. Progress prompts for an input file from which to load the SQL Views. The default filename is _view.d.
3. Specify the filename or accept the default. After loading the view contents from the specified file, Progress displays a status message and prompts for a continue.
4. Choose OK to return to the Data Administration or DataDictionary main window.