HP c-tree-SQL ISQL and Tools manual

ISQL and Tools Reference Guide

For use with c-treeSQL Server

This manual provides reference material for the ISQL interactive SQL utility and other administrative tools provided in the c-treeSQL environment. It also includes a tutorial describing how to use the ISQL utility.

Contents

ISQL and Tools Reference Guide Page Documentation Overview 1 Introduction 2 Quick Tour 3 ISQL Statements FairCom Corporation 4 Data Load Utility: dbload 5 Data Unload Utility: dbdump 6 Schema Export Utility: dbschema A Tutorial Source Code Index Index-i List of Figures Page Documentation Overview PURPOSE OF THIS MANUAL AUDIENCE STRUCTURE SYNTAX DIAGRAM CONVENTIONS RELATED DOCUMENTATION Introduction 1.1OVERVIEW Page Quick Tour 2.1INTRODUCTORY TUTORIAL Add Records Display Records Delete Records 2.2RELATIONAL MODEL AND INDEXING TUTORIAL Relational Database OrderList OrderItem ItemMaster CustomerMaster orderlist 2.2.3Manage 2.2.4Done 2.2.5Complete Relational Model and Indexing Tutorial Source Code 2.3LOCKING TUTORIAL 2.3.2Define 2.3.3Manage Update Record 2.3.5Complete Locking Tutorial Source Code 2.4TRANSACTION PROCESSING TUTORIAL Transaction 2.4.3Manage 2.4.4Done 2.4.5Complete Transaction Processing Tutorial Source Code ISQL Statements 3.1OVERVIEW 3.2STARTING INTERACTIVE SQL 3.3STATEMENT HISTORY SUPPORT 3.4FORMATTING OUTPUT OF ISQL QUERIES Page Page 3.4.1Formatting Column Display with the COLUMN Statement 3.4.2Summarizing Data with DISPLAY, COMPUTE, and BREAK State- ments Page 3.4.3Adding Beginning and Concluding Titles with the TITLE Statement Page 3.5THE HELP AND TABLE STATEMENTS 3.6TRANSACTION SUPPORT 3.7ISQL REFERENCE 3.7.2BREAK SKIP n Examples 3.7.3CLEAR Argument option 3.7.4COLUMN FORMAT " format_string HEADING " heading_text (a) Format String Details Page Page 3.7.5COMPUTE AVG | MAX | MIN | SUM | COUNT 3.7.6DEFINE value 3.7.7DISPLAY col_position display_value 3.7.8EDIT 3.7.9EXIT or QUIT Related Statements 3.7.10GET Page 3.7.11HELP 3.7.12HISTORY Page 3.7.13HOST or SH or HOST | SH | host_command 3.7.14LIST 3.7.15QUIT or EXIT 3.7.16RUN 3.7.17SAVE 3.7.18SET HISTORY PAGESIZE number_lines LINESIZE COMMAND LINES REPORT ON | OFF DISPLAY COST ON | OFF AUTOCOMMIT ON | OFF TRANSACTION ISOLATION LEVEL isolation_level CONNECTION { database_name | DEFAULT} 3.7.19SHOW 3.7.20SPOOL filename ON OFF OUT 3.7.21START argument … 3.7.22TABLE Page 3.7.23TITLE TOP | BOTTOM LEFT | CENTER | RIGHT | COL n " text Page Page Data Load Utility: dbload 4.1INTRODUCTION 4.2PREREQUISITES FOR DBLOAD 4.3DBLOAD COMMAND LINE SYNTAX 4.4DATA FILE FORMATS 4.5THE COMMANDS FILE 4.5.1The DEFINE RECORD Statement 4.5.2The FOR EACH Statement 4.6EXAMPLES ERRORS Position for SHORT not specified correctly Position for LONG not specified correctly Position for FLOAT not specified correctly Position for DOUBLE not specified correctly Field delimiter must be a single character Page Data Unload Utility: dbdump 5.1INTRODUCTION 5.2PREREQUISITES FOR DBDUMP 5.3DBDUMP COMMAND LINE SYNTAX 5.4DATA FILE FORMATS 5.5THE COMMANDS FILE Data Unload Utility: dbdump 5.5.1The DEFINE RECORD Statement 5.6EXAMPLES Page Page Schema Export Utility: dbschema 6.1INTRODUCTION 6.2EXAMPLES Schema Export Utility: dbschema Page Tutorial Source Code A.1 INTRODUCTORY TUTORIAL A.2 RELATIONAL MODEL AND INDEXING TUTORIAL A-2 A.3 LOCKING TUTORIAL A.4 TRANSACTION PROCESSING TUTORIAL A-4 A-5 Page Symbols Index-ii Index Index-iii