HP
c-tree-SQL ISQL and Tools
manual
Isql and Tools FairCom Corporation
Syntax Diagram Conventions
Password
Is Default ?
Symbols
Help Commandsclauses
Username.procedurename
Page 90
ISQL and Tools
6-4
FairCom Corporation
Page 89
Page 91
Image 90
Page 89
Page 91
Contents
Isql and Tools Reference Guide
For use with c-treeSQL Server
Page
Table of Contents
Data Load Utility dbload
Tutorial Source Code
Iii
FairCom Corporation
Purpose of this Manual
Syntax Diagram Conventions
Documentation Overview
Audience
Related Documentation
Isql and Tools
Introduction
Overview
Isql and Tools FairCom Corporation
Init
Quick Tour
Introductory Tutorial
Isql
Isql Create Table Custmast
Define
Manage
Isql Commit Work Custmast
Done
Complete Introductory Tutorial Code
Quick Tour
Relational Model and Indexing Tutorial
ISQLTutorial2.sql
Quick Tour
Insert Into
Values Insert Into
Values
Commit Work
QTY Price
Complete Relational Model and Indexing Tutorial Source Code
Locking Tutorial
ISQLTutorial3.sql
@ISQL @iSQLTutorial3.sql
Isql Delete from Custmast
Complete Locking Tutorial Source Code
Transaction Processing Tutorial
ISQLTutorial4.sql
Transaction
Rollback Work
Complete Transaction Processing Tutorial Source Code
Syntax
Isql Statements
Starting Interactive SQL
Arguments
Username
Password
Statement History Support
Connectstring
Isql Statements for Statement History Support
Formatting Output of Isql Queries
Isql Statements
Statement Summary
Isql Statements for Query Formatting Summary
Display
Example 3-1 Unformatted Query Display from Isql
Customername Customercity Orderid Ordervalue
Formatting Column Display with the Column Statement
Example 3-2 Controlling Display Width of Character Columns
Example 3-3 Customizing Format of Numeric Column Displays
Ordervalue
Customername Customercity
Example 3-4 Specifying Column Breaks and Values with Display
Numorders Customername
Example 3-6 Specifying a Query Header and Footer with Title
Help and Table Statements
Transaction Support
Description
Isql Reference
1 @ Execute Syntax
Example
Break Syntax
Breakspec
Examples
Skip n
Customername
Clear Syntax
History
Option
Argument
Column Syntax
Break Column Compute Display Title
Columnname
Format formatstring
Heading headingtext
Date-Time Format Strings for the Column Statement
Character Description
Null ? Type Length Colname
Not Null INT
Char
Orderinfo
Amount
Sysdate
NEW Title
FLD
Column Title
Compute
AVG MAX MIN SUM Count
Variablename
Define Syntax
Value
COL columnnumber
Colposition
Displayvalue
@columnname
Edit Syntax
Exit or Quit Syntax
Related Statements
Exit
10 GET Syntax
Isql GET query.sql
Isql RUN
History Syntax
Help Commandsclauses
Help Syntax
Orderstate Lotlocation
Following example illustrates usage of the History statement
Hostcommand
Host or SH or Syntax
From
List Syntax
Quit
Quit or Exit Syntax
16 RUN Syntax
Isql History
Pagesize
Save Syntax
18 SET Syntax
Linesize
Pagesize numberlines
Isql Break on Isql Select TBL from Systables TBL
Connection databasename Default
Transaction Isolation Level isolationlevel
TBL
Show Syntax
Filename on
Is Default ?
Spool Syntax
Database Connections
Isql Spool STK on
Start Syntax
Argument …
Isql Spool OFF
Null ? Type Length Colname Not Null INT
Not Null Varchar
Tablename
Type Length Colname Null ?
Date
Text
Title Syntax
Left Center Right COL n
Double
Isql Clear Title
Isql and Tools FairCom Corporation
Data Load Utility dbload
Introduction
Prerequisites for Dbload
Dbload Command Line Syntax
Commandsfile
Options
Data File Formats
Data Load Utility dbload
Fixed Length Records
Commands File
Variable Length Records
Next Record
Define Record Statement
Char Short Long Float Double
For Each Statement
Null
Example 4-1 Sample dbload commands files
Examples
Compilation Errors
Record name redefined
Position not specified for fixed length record
Fatal Errors
Isql and Tools FairCom Corporation
Data Unload Utility dbdump
Prerequisites for Dbdump
Dbdump Command Line Syntax
Data Unload Utility dbdump
Short Long Float Double
For Record Statement
Define Record custrec of Fixed Length 37 AS
Isql and Tools FairCom Corporation
Schema Export Utility dbschema
Username.tablename
Username.procedurename
Outfile
Username.triggername
Import Begin
Schema Export Utility dbschema
Dbschema
END
Isql and Tools FairCom Corporation
Tutorial Source Code
Commit Work Select * from Custmast Delete from Custmast
Integer
Money
VARCHAR6
Tutorial Source Code
Commit Work Delete from Custmast
Imdesc VARCHAR48
Select * from orderlist Select * from orderitems
Isql and Tools FairCom Corporation
Symbols
Index-i
Isql
Index-ii FairCom Corporation
Index
Index-iii FairCom Corporation
Related pages
What makes the
Definitive Technology BP 30
speakers a top choice for audiophiles?
Top
Page
Image
Contents