HyperSQL Utilities Guide

Edited by

The HSQLB Development Group

Edited by

Blaine Simpson

The HSQL Development Group

Edited by

Fred Toussi

The HSQL Development Group

$Revision: 3539 $

Copyright 2002-2009 The HSQL Development Group. Permission is granted to distribute this document without any alteration under the terms of the HSQLDB license.

$Date: 2010-03-17 11:47:21 -0400 (Wed, 17 Mar 2010) $


Table of Contents

Preface
Available formats for this document
1. SqlTool
Purpose, Coverage, Changes in Behavior
Platforms and SqlTool versions covered
Recent Functional Changes
New Features
The Bare Minimum
Embedding
Non-displayable Types
Desktop shortcuts
Loading sample data
Satisfying SqlTool's CLASSPATH Requirements
Accessing older HSQLDB Databases with SqlTool
App-specific Classes, Embedding, and non-HyperSQL Databases
Distributing SqlTool with your Apps
SqlTool Client PCs
RC File Authentication Setup
Switching Data Sources
Using Inline RC Authentication
Logging
Interactive Usage
SqlTool Command-Line Editing
Command Types
Command Types
Special Commands
Edit Buffer / History Commands
PL Commands
? Variable
Storing and retrieving binary files
Command History
Shell scripting and command-line piping
Emulating Non-Interactive mode
Non-Interactive
Giving SQL on the Command Line
SQL Files
Piping and shell scripting
Optimally Compatible SQL Files
Comments
Special Commands and Edit Buffer Commands in SQL Files
Automation
Getting Interactive Functionality with SQL Files
Character Encoding
Generating Text or HTML Reports
SqlTool Procedural Language
Variables
Macros
PL Sample
Logical Expressions
Flow Control
Example
Chunking
Why?
How?
Raw Mode
SQL/PSM, SQL/JRT, and PL/SQL
Delimiter-Separated-Value Imports and Exports
Simple DSV exports and imports using default settings
Specifying queries and options
Unit Testing SqlTool
2. Hsqldb Test Utility
3. Database Manager
Brief Introduction
Auto tree-update
Automatic Connection
RC File
Using the current DatabaseManagers with an older HSQLDB distribution.
DatabaseManagerSwing as an Applet
4. Transfer Tool
Brief Introduction
A. HyperSQL File Links

List of Tables

1. Available formats of this document

List of Examples

1.1. Sample RC File
1.2. Inserting binary data into database from a file
1.3. Downloading binary data from database to a file
1.4. Piping input into SqlTool
1.5. Simple SQL file using PL
1.6. SQL File showing use of most PL features
1.7. Interactive Raw Mode example
1.8. PL/SQL Example
1.9. SQL/JRT Example
1.10. SQL/PSM Example
1.11. DSV Export Example
1.12. DSV Import Example
1.13. DSV Export of an Arbitrary SELECT Statement
1.14. Sample DSV headerswitch settings
1.15. DSV targettable setting

$Revision: 3539 $