HP c-tree-SQL ISQL and Tools manual Symbols, Index-i

Page 97

Symbols

@Execute syntax . . . . . . . . . . . . . . . . . . . . . 3-12

A

Adding titles . . . . . . . . . . . . . . . . . . . . . . . . . . 3-9

B

Beginning titles . . . . . . . . . . . . . . . . . . . . . . . 3-9BREAK statement . . . . . . . . . . . . . . . . . . . . . 3-4BREAK statement syntax . . . . . . . . . . . . . . 3-13

C

CLEAR statement . . . . . . . . . . . . . . . . . . . . . 3-4CLEAR statement syntax . . . . . . . . . . . . . . . 3-15Column display formatting . . . . . . . . . . . . . . 3-6COLUMN statement . . . . . . . . . . . . . . . . . . . 3-4COLUMN statement date-time formats . . . . 3-18COLUMN statement numeric formats . . . . . 3-18COLUMN statement syntax . . . . . . . . . . . . . 3-16Commands file . . . . . . . . . . . . . . . . . . . . 4-4,5-2COMPUTE statement . . . . . . . . . . . . . . . . . . 3-4COMPUTE statement syntax . . . . . . . . . . . . 3-21Concluding titles . . . . . . . . . . . . . . . . . . . . . . 3-9

D

Data file formats for dbdump . . . . . . . . . . . . . 5-2Data file formats for dbload . . . . . . . . . . . . . . 4-3Data summaries . . . . . . . . . . . . . . . . . . . . . . . 3-7Date-time formats for COLUMN statement 3-18dbdump

commands file . . . . . . . . . . . . . . . . . . . . . 5-2data file formats . . . . . . . . . . . . . . . . . . . 5-2DEFINE RECORDS statement . . . . . . . . 5-3examples . . . . . . . . . . . . . . . . . . . . . . . . . 5-4execution process diagram . . . . . . . . . . . 5-1

Index

FOR RECORD statement . . . . . . . . . . . . 5-4overview . . . . . . . . . . . . . . . . . . . . . . . . . 5-1prerequisites . . . . . . . . . . . . . . . . . . . . . . 5-1syntax . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-2

dbload

commands file . . . . . . . . . . . . . . . . . . . . . 4-4data file formats . . . . . . . . . . . . . . . . . . . 4-3DEFINE RECORDS statement . . . . . . . 4-5errors . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4-8examples . . . . . . . . . . . . . . . . . . . . . . . . . 4-7execution process diagram . . . . . . . . . . . 4-1fixed length records . . . . . . . . . . . . . . . . 4-4FOR EACH statement . . . . . . . . . . . . . . 4-6overview . . . . . . . . . . . . . . . . . . . . . . . . . 4-1prerequisites . . . . . . . . . . . . . . . . . . . . . . 4-2syntax . . . . . . . . . . . . . . . . . . . . . . . . . . . 4-2variable length records . . . . . . . . . . . . . . 4-4

dbschema

examples . . . . . . . . . . . . . . . . . . . . . . . . . 6-2overview . . . . . . . . . . . . . . . . . . . . . . . . . 6-1syntax . . . . . . . . . . . . . . . . . . . . . . . . . . . 6-1DEFINE RECORDS statement . . . . . . . 4-5,5-3DEFINE statement . . . . . . . . . . . . . . . . . . . . . 3-4DEFINE statement syntax . . . . . . . . . . . . . . 3-23DISPLAY statement . . . . . . . . . . . . . . . . . . . 3-4DISPLAY statement syntax . . . . . . . . . . . . . 3-23

E

EDIT statement . . . . . . . . . . . . . . . . . . . . . . . 3-3EDIT statement syntax . . . . . . . . . . . . . . . . . 3-25Errors

dbload . . . . . . . . . . . . . . . . . . . . . . . . . . . 4-8EXIT statement syntax . . . . . . . . . . . . . . . . . 3-26

F

Fixed length records for dbload . . . . . . . . . . . 4-4FOR EACH statement . . . . . . . . . . . . . . . . . . 4-6FOR RECORD statement . . . . . . . . . . . . . . . 5-4Formatting column displays . . . . . . . . . . . . . . 3-6

FairCom Corporation

Index-i

Page 96 Page 98
Image 97
Page 96 Page 98
Contents For use with c-treeSQL Server Isql and Tools Reference GuidePage Table of Contents Data Load Utility dbload Iii Tutorial Source CodeFairCom Corporation Documentation Overview Syntax Diagram ConventionsPurpose of this Manual AudienceIsql and Tools Related DocumentationOverview IntroductionIsql and Tools FairCom Corporation Introductory Tutorial Quick TourInit IsqlManage DefineIsql Create Table Custmast Isql Commit Work CustmastComplete Introductory Tutorial Code DoneQuick Tour ISQLTutorial2.sql Relational Model and Indexing TutorialQuick Tour Values Insert Into Insert IntoValues QTY Price Commit WorkComplete Relational Model and Indexing Tutorial Source Code ISQLTutorial3.sql Locking Tutorial@ISQL @iSQLTutorial3.sql Isql Delete from Custmast Complete Locking Tutorial Source Code ISQLTutorial4.sql Transaction Processing TutorialTransaction Rollback Work Complete Transaction Processing Tutorial Source Code Starting Interactive SQL Isql StatementsSyntax ArgumentsStatement History Support PasswordUsername ConnectstringIsql Statements Formatting Output of Isql QueriesIsql Statements for Statement History Support Statement SummaryDisplay Isql Statements for Query Formatting SummaryCustomername Customercity Orderid Ordervalue Example 3-1 Unformatted Query Display from IsqlExample 3-2 Controlling Display Width of Character Columns Formatting Column Display with the Column StatementOrdervalue Example 3-3 Customizing Format of Numeric Column DisplaysCustomername Customercity Example 3-4 Specifying Column Breaks and Values with Display Numorders Customername Example 3-6 Specifying a Query Header and Footer with Title Transaction Support Help and Table Statements1 @ Execute Syntax Isql ReferenceDescription ExampleBreakspec Break SyntaxSkip n ExamplesCustomername History Clear SyntaxColumn Syntax ArgumentOption Break Column Compute Display TitleFormat formatstring ColumnnameHeading headingtext Character Description Date-Time Format Strings for the Column StatementNot Null INT Null ? Type Length ColnameChar Amount OrderinfoSysdate Column Title FLDNEW Title ComputeVariablename AVG MAX MIN SUM CountValue Define SyntaxDisplayvalue ColpositionCOL columnnumber @columnnameEdit Syntax Related Statements Exit or Quit SyntaxExit Isql GET query.sql 10 GET SyntaxIsql RUN Help Syntax Help CommandsclausesHistory Syntax Orderstate LotlocationFollowing example illustrates usage of the History statement Host or SH or Syntax HostcommandFrom List Syntax 16 RUN Syntax Quit or Exit SyntaxQuit Isql History18 SET Syntax Save SyntaxPagesize LinesizePagesize numberlines Transaction Isolation Level isolationlevel Connection databasename DefaultIsql Break on Isql Select TBL from Systables TBL TBLShow Syntax Spool Syntax Is Default ?Filename on Database ConnectionsArgument … Start SyntaxIsql Spool STK on Isql Spool OFFNot Null Varchar Null ? Type Length Colname Not Null INTType Length Colname Null ? TablenameDate Left Center Right COL n Title SyntaxText DoubleIsql Clear Title Isql and Tools FairCom Corporation Introduction Data Load Utility dbloadCommandsfile Dbload Command Line SyntaxPrerequisites for Dbload OptionsData Load Utility dbload Data File FormatsVariable Length Records Commands FileFixed Length Records Next RecordChar Short Long Float Double Define Record StatementNull For Each StatementExamples Example 4-1 Sample dbload commands filesRecord name redefined Compilation ErrorsPosition not specified for fixed length record Fatal Errors Isql and Tools FairCom Corporation Prerequisites for Dbdump Data Unload Utility dbdumpDbdump Command Line Syntax Short Long Float Double Data Unload Utility dbdumpFor Record Statement Define Record custrec of Fixed Length 37 AS Isql and Tools FairCom Corporation Schema Export Utility dbschema Outfile Username.procedurenameUsername.tablename Username.triggernameDbschema Schema Export Utility dbschemaImport Begin ENDIsql and Tools FairCom Corporation Commit Work Select * from Custmast Delete from Custmast Tutorial Source CodeMoney IntegerVARCHAR6 Commit Work Delete from Custmast Tutorial Source CodeImdesc VARCHAR48 Select * from orderlist Select * from orderitems Isql and Tools FairCom Corporation Index-i SymbolsIndex-ii FairCom Corporation IsqlIndex-iii FairCom Corporation Index
Top Page Image Contents