| HyperSQL Utilities Guide |
|  | Preface

# 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-2011 The HSQL Development Group. Permission is granted to distribute this document without any alteration under the terms of the HSQLDB license.

2012-08-06 00:15:58+0100

List of Tables

1. Available formats of this document

List of Examples

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

$Revision: 4904 $

|  | Preface