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

Copyright 2002-2019 Blaine Simpson, Fred Toussi and The HSQL Development Group. Permission is granted to distribute this document without any alteration under the terms of the HSQLDB license. You are not allowed to distribute or display this document on the web in an altered form.

2022-10-20


Table of Contents

Preface
Available formats for this document
1. SqlTool
Try It
Purpose, Coverage, Recent Changes in Behavior
Platforms and SqlTool versions covered
Recent Functional Changes
New Features
The Bare Minimum
Quotes and Spaces
Embedding
Non-displayable Types
Compound commands or commands with semi-colons
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
Emulating Non-Interactive mode
Command Types
Special Commands
Edit Buffer / History Commands
Command History
PL Commands
Non-Interactive
Giving SQL on the Command Line
SQL Files
Piping and shell scripting
Automation
Optimally Compatible SQL Files
Comments
Special Commands and Edit Buffer Commands in SQL Files
Getting Interactive Functionality with SQL Files
Character Encoding
Generating Text or HTML Reports
Storing and Retrieving Binary Files
SqlTool Procedural Language
Nulls and Empty Strings
Variables
Macros
SqlTool Functions
PL Sample
Logical Expressions
Mathematical Assignments
Flow Control
PL 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
CSV Imports and Exports
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. SqlTool System PL Variables
B. HyperSQL File Links

List of Tables

1. Available formats of this document

List of Examples

1.1. Sample RC File
1.2. Default parameter value with optional user-specified override
1.3. Piping input into SqlTool
1.4. Redirecting input into SqlTool
1.5. Error-handling Idiom
1.6. Sample HTML Report Generation Script
1.7. Inserting binary data into database from a file
1.8. Downloading binary data from database to a file
1.9. Example to avoid accidental Comment
1.10. Explicit null and empty-string Tests
1.11. Special values for ?, and _ (or ~) Variables
1.12. Creating a SqlTool Function
1.13. Invoking a SqlTool Function
1.14. Simple SQL file using PL
1.15. Inline If Statement
1.16. SQL File showing use of most PL features
1.17. Interactive Raw Mode example
1.18. PL/SQL Example
1.19. SQL/JRT Example
1.20. SQL/PSM Example
1.21. DSV Export Example
1.22. DSV Import Example
1.23. DSV Export of an Arbitrary Query
1.24. Sample DSV headerswitch settings
1.25. DSV targettable setting
1.26. Sample CSV export + import script

$Revision: 6065 $