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.