The steps for loading the contents of an SQL view file are similar to those for loading table and user table contents.

To load an SQL view file's contents:

  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. Choose Admin > Load Data and Definitions > SQL Views. The Data tool prompts you 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 file contents from the specified file, the Data tool displays a status message and prompts you to continue.
  4. 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.