Cloudview On-Line Help

Overview

Cloudview is an interface for graphically creating, examining, and managing Cloudscape databases.

Using Cloudview

Dictionary Objects

Working with Dictionary Objects

Working with Data, SQL-J, and Java Objects

Common Cloudview Tasks

Use Cloudview to easily create, view, and manage Cloudscape databases.

The following table lists some common Cloudview tasks. The right column shows how to access that feature from the Cloudview menu.

Click a blue diamond to go to the associated topic:

Task Main Menu Option Button

Open a database

File->Open
File->Open by Name

Create a database

File->New->Database

Create an object in the database:

  • Table, Index, Check, or Key
  • View
  • Alias
  • Jar File
  • Publication
  • Stored Statement
  • Trigger

Edit->New->

Open an additional Cloudview window

File->New->Window

Delete one or more objects

Edit->Delete
(when object or objects are highlighted)

Insert data into a table

Execute an SQL-J statement against the database

Import or Export Data

Edit->Import
Edit->Export

(when a table name is selected)

Close a Database

File->Close
(when any node in the database is selected)

Exit Cloudview

File->Exit

Examine an Object

Browse Data

See the SQL-J statement that created an object

Inspect a Java Object

Modify or view connection settings

View System Objects

View->System Tables
View->System Stored Statements

View Data in Locale-specific Format

View->Localized Data Representation

Most of these tasks can also be performed using SQL-J statements from Cloudview. For information about submitting SQL-J statements from Cloudview, see the section "Submitting SQL-J Statements".

Exiting Cloudview

NOTE: Prior to exiting Cloudview, you should explicitly close any databases open in the window you are closing. (For information, see "Closing the Connection to a Database").

NOTE: If you have spawned multiple connections to a database (by opening multiple windows), Cloudview only closes the connection established by the window being closed. Before you can release a database lock in this circumstance, you must free all connections by closing the database from each open Cloudview window.