Creating a View

  1. To create a new view, do one of the following:
  2. Type the view name in the Name box.
  3. Choose the Schema for the view. By default, the schema is APP.
  4. In the Query field, specify the statement text for the view. If necessary, you can use the Auto Text feature to help populate your SQL statement:
  5. Optionally, click the Execute icon to test the statement. The results are displayed in the bottom, right panel.
  6. If satisfied with the view definition, click OK to save the view. To cancel view creation, click CANCEL.

NEW: In Cloudscape 5.2, you can use the Add All Columns button (next to the + and - buttons on the Columns tab) to add all available columns to the view. The columns are added with default names that can then be changed. The Add All Columns button is only available after you type a valid SQL select statement in the Execute Query panel for the view.