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 96
ISQL and Tools
A-6
FairCom Corporation
Page 95
Page 97
Image 96
Page 95
Page 97
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
Syntax Diagram Conventions
Documentation Overview
Purpose of this Manual
Audience
Related Documentation
Isql and Tools
Introduction
Overview
Isql and Tools FairCom Corporation
Quick Tour
Introductory Tutorial
Init
Isql
Define
Manage
Isql Create Table Custmast
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
Isql Statements
Starting Interactive SQL
Syntax
Arguments
Password
Statement History Support
Username
Connectstring
Formatting Output of Isql Queries
Isql Statements
Isql Statements for Statement History Support
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
Isql Reference
1 @ Execute Syntax
Description
Example
Break Syntax
Breakspec
Examples
Skip n
Customername
Clear Syntax
History
Argument
Column Syntax
Option
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
FLD
Column Title
NEW Title
Compute
AVG MAX MIN SUM Count
Variablename
Define Syntax
Value
Colposition
Displayvalue
COL columnnumber
@columnname
Edit Syntax
Exit or Quit Syntax
Related Statements
Exit
10 GET Syntax
Isql GET query.sql
Isql RUN
Help Commandsclauses
Help Syntax
History Syntax
Orderstate Lotlocation
Following example illustrates usage of the History statement
Hostcommand
Host or SH or Syntax
From
List Syntax
Quit or Exit Syntax
16 RUN Syntax
Quit
Isql History
Save Syntax
18 SET Syntax
Pagesize
Linesize
Pagesize numberlines
Connection databasename Default
Transaction Isolation Level isolationlevel
Isql Break on Isql Select TBL from Systables TBL
TBL
Show Syntax
Is Default ?
Spool Syntax
Filename on
Database Connections
Start Syntax
Argument …
Isql Spool STK on
Isql Spool OFF
Null ? Type Length Colname Not Null INT
Not Null Varchar
Tablename
Type Length Colname Null ?
Date
Title Syntax
Left Center Right COL n
Text
Double
Isql Clear Title
Isql and Tools FairCom Corporation
Data Load Utility dbload
Introduction
Dbload Command Line Syntax
Commandsfile
Prerequisites for Dbload
Options
Data File Formats
Data Load Utility dbload
Commands File
Variable Length Records
Fixed 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.procedurename
Outfile
Username.tablename
Username.triggername
Schema Export Utility dbschema
Dbschema
Import Begin
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
How do I fix a
Gaggenau steam oven
error code?
Top
Page
Image
Contents