Try OpenEdge Now
skip to main content
Database Administration
Maintaining and Monitoring Your Database : Dumping and Loading : Dumping database contents : Dumping an SQL view file's contents with a Data tool
Dumping an SQL view file's contents with a Data tool
The procedure for dumping the contents of an SQL file is similar to the procedures for dumping table contents and sequence values.
To dump the contents of a SQL view:
1. Access the appropriate Data tool (the Data Administration tool if you are using a graphical interface or the Data Dictionary if you are using a character interface).
2. Make sure you are using the database (the source) where you want to dump the table data.
3. Choose Admin > Dump Data and Definitions > Views. The Data tool prompts you for the file, then for the file that you want to write the user file contents to. The default filename is _view.d.
4. Specify the filename or accept the default. After dumping the view file contents to the specified file, the Data tool displays a status message and prompts you to continue.
5. Choose OK to return to the Data Administration or Data Dictionary main window.
Note: For a complete description of dumping and loading SQL content, see SQL Utilities.