Table of Contents
Page 1 of 1

Table of Contents

About This Book

1 What Are the Cloudscape Tools and Utilities?

Overview

JDK and Class Path for Cloudscape Tools

JDK

Class Path

About Cloudscape Databases

JDBC Basics

Drivers

Database Connection URLs

Tools and Localization

About Locales

Database Locale

Specifying a Locale for Messages and Display Text

Specifying an Alternate Codeset

Formatting Display of Locale-sensitive Data

Importing and Exporting Data Between Locales and Codesets

2 Using Cloudview

What Is Cloudview?

Starting Cloudview

Cloudview Log

CloudviewProperties

Locale and Codeset Properties

SysVisual.properties File

Cloudview On-Line Help

Cloudview's Stored Prepared Statements

Cloudview and Cloudscape Synchronization Features

Connecting to a Server

Using Cloudview

3 Using ij

Starting ij

ij Properties

Getting Started with ij

Connecting to a Cloudscape Database

ij and Servers

Using ij Commands

Other Uses for ij

Running ij Scripts

4 ij Properties Reference

Generic Tool Properties

ij.connection.connectionName

ij.database

ij.driver

ij.maximumDisplayWidth

ij.outfile

ij.protocol

ij.protocol.protocolName

ij.showErrorCode

ij.unicodeEscape

ij.URLCheck

cloudscape.ui.codeset

cloudscape.ui.locale

5 ij Commands and Errors Reference

ij Commands

Conventions for ij Examples

ij SQL Command Behavior

Absolute

After Last

Async

Autocommit

Before First

Close

Commit

Connect

Disconnect

Driver

Elapsedtime

Execute

Exit

First

Get Cursor

Get Scroll Insensitive Cursor

Help

Last

LocalizedDisplay

MaximumDisplayWidth

Next

Prepare

Previous

Protocol

Readonly

Relative

Remove

Rollback

Run

Set Connection

Show Connections

UnicodeEscape

Wait For

Comment

Identifier

String

ERROR SQLState

WARNING SQLState

IJ ERROR

IJ WARNING

JAVA ERROR

6 Using the Bulk Import and Export Utilities

Overview

Options for Running Import and Export

Preparation, Requirements, and Use

Slow and Fast Modes for Import

Fast Mode Requirements

Using the Utilities

Using Bulk Import and Export from Cloudview

Bulk Import and Export Stand-Alone Utilities

Arguments to Import and Export Utility Commands

Bulk Import and Export Utility Examples

Bulk Import and Export From an SQL-J Statement

To Bulk-Import

Arguments to the Import Command

Parameter Sets for the FileImport Constructor

Parameter Sets for the Static Import Method in FileImport

To Bulk-Export

Parameter Sets for COM.cloudscape.tools.FileExport.Export

Properties

Import Properties

insertMode

bulkFetch

Examples of Bulk Import and Export Within SQL-J Statements

Localization-Related Properties

Default Input or Output File Format

About the Control File

Locale and Codeset Parameters

DataLocale

DataCodeset

Treatment of NULLS

Autoincrement Defaults

7 Using the Database Class Utilities

Storing Jar Files in a Database

Working with the Utility

Adding a Jar File

Removing a Jar File

Replacing a Jar File

Complete Examples

Forcing Database Class Loading for an Application

8 sysinfo

Example

Using sysinfo to Check the Classpath

Index