Table of Contents (Go to Index)

Overview
Using Cloudview
Dictionary Objects
Working with Dictionary Objects
Working with Data, SQL-J, and Java Objects
Common Cloudview Tasks
Exiting Cloudview
The Cloudview Window
Navigation Panel
System Icon
Dictionary Object Icons
Edit Panel
Menu Bar
Opening Multiple Cloudview Windows
Databases
Submitting SQL-J Statements
Database Tab
SQL Window
Executing Statements from the SQL Window
Executing from a Script File
Saving SQL-J Statements to a File
Using Auto Text
Statistics
Stopping a Statement
Seeing Previous Statements
Case Sensitivity in the SQL Window
Working with Dictionary Objects
Closing the Connection to a Database
Close
Shutdown and Close
Deleting a Database
Setting Database Properties
About Database Properties in Cloudview
Properties Tab
Description of Properties
Converting to a Source Database
The Cloudscape System Panel
What Is the Cloudscape System?
Working in the Cloudscape System
System Settings
Connection Tab
Preferences Tab
Information Tab
Modifying Connection Properties
About Connection Settings
URL
Log-in
Driver
About the System Directory
Creating or Opening Databases
Creating a Database
The New Database Dialog
Where is the Database Created?
Opening an Existing Database
From the File History List
Using the Directory Browser
By Name
From the Command Line or Shortcut
Tables
Creating and Modifying Tables and Table Objects
Creating a Table
Modifying an Existing Table
Case Sensitivity in Table and Column Names
Creating Indexes
Creating a Key
Creating a Check Constraint
Deleting Tables and Table Objects
Deleting Indexes
Deleting Keys
Deleting Check Constraints
Saving New Tables and Columns Automatically
Working with Tables
Examining Tables and Table Objects
Examining Tables
Examining Columns
Examining Indexes
Examining Keys
Examining Check Constraints
Examining a Table's Properties
Examining the Statement That Created a Table
Viewing, Inserting, and Modifying Data
Selecting the Table
Viewing Data
Viewing Data in a Different Locale
Insert, Delete, or Modify Data
Inspecting Java Objects in Data
System Objects
System Tables
System Stored Statements
Dictionary Objects
Creating Dictionary Objects
Deleting Objects
Examining Objects
Views
Creating a View
Examining the Statement That Created a View
Examining Data in a View
Deleting a View
Aliases
About Aliases
Creating Aliases
Examining Existing Aliases
Deleting Aliases
Stored Statements
Creating Stored Statements
Examining Stored Statements
Recompiling Stored Statements
Executing Stored Statements
Deleting Stored Statements
Jar Files
Adding a Jar File
Executing a Jar File
Examining Jar Files
Removing Jar Files
Updating and Replacing Jar Files
Publications
Creating a Publication
Publication Tab
Items Tab
Properties Tab
SQL Tab
Accessing a Publication
Examining the CREATE PUBLICATION Statement
Examining Publication Objects
Views
Indexes
Check Constraints
Creating a Copy File
Deleting a Publication
Refreshing a Target
Triggers
Creating a Trigger
Triggers Tab
Options Tab
SQL Tab
Deleting a Trigger
Enabling or Disabling a Trigger
Viewing a Trigger
Inspecting Java Objects
Java Object Fields
Java Object Methods
Superclass and Interface Methods for a Java Object
Executing Methods with No Parameters
Importing and Exporting Data
Import/Export File Types
Note Regarding Import and Autoincrement Default Columns
Opening the Import/Export Window
Simple Import/Export
Advanced Import/Export
Delimited Data
Fixed-Width Data
Control Files
Configuring Cloudview
Cloudview's Stored Prepared Statements
Cloudview Log
Cloudview Properties