HP c-tree-SQL ISQL and Tools manual Formatting Output of Isql Queries, Isql Statements

Page 29

 

 

 

ISQL Statements

 

 

 

 

Table 3-1: ISQL Statements for Statement History Support

 

 

 

 

 

Statement

 

Summary

 

 

 

 

 

RUN [ stmt_num ]

 

Displays and executes the current statement or specified state-

 

 

 

ment in the history buffer. See Section 3.7.16 "RUN" on page 3-

 

 

 

33 details.

 

 

 

 

 

LIST [ stmt_num ]

 

Displays the current statement or specified statement in the his-

 

 

 

tory buffer, and makes that statement the current statement by

 

 

 

copying it to the end of the history list. See Section 3.7.14 "LIST"

 

 

 

on page 3-32 for details.

 

 

 

 

 

EDIT [ stmt_num ]

 

Edits the current statement or specified statement in the history

 

 

 

buffer, and makes the edited statement the current statement by

 

 

 

copying it to the end of the history list. The environment variable

 

 

 

EDITOR can be set to the editor of choice. See Section 3.7.8

 

 

 

"EDIT" on page 3-25 for details.

 

 

 

 

 

SAVE filename

 

Saves the current statement in the history buffer to the specified

 

 

 

file, which can then be retrieved through the GET or START

 

 

 

statements. See Section 3.7.17 "SAVE" on page 3-34 for details.

 

 

 

 

 

GET filename

 

Fetches the contents of the specified file, from the beginning of

 

 

 

the file to the first semicolon, and appends it to the history buffer.

 

 

 

The statement fetched by the GET can then be executed by

 

 

 

using the RUN statement. See Section 3.7.10 "GET" on page 3-

 

 

 

27 for details.

 

 

 

 

 

START filename

[

Fetches and executes a statement stored in the specified file.

 

argument … ]

 

Unlike the GET statement, START executes the statement and

 

 

 

accepts arguments that it substitutes for parameter references in

 

 

 

the statement stored in the file. START also appends the state-

 

 

 

ment to the history buffer. See Section 3.7.21 "START" on page

 

 

 

3-39 for details.

 

 

 

 

3.4FORMATTING OUTPUT OF ISQL QUERIES

Formatting of database query results makes the output of a database query more presentable and understandable. The formatted output of an ISQL database query can be either displayed on the screen, written to a file, or spooled to a printer to produce a hardcopy of the report.

FairCom Corporation

3-3

Image 29
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 CustmastQuick Tour DoneComplete Introductory Tutorial Code ISQLTutorial2.sql Relational Model and Indexing TutorialQuick Tour Values Insert IntoValues Insert Into 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 StatementCustomername Customercity Example 3-3 Customizing Format of Numeric Column DisplaysOrdervalue 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 SyntaxCustomername ExamplesSkip n History Clear SyntaxColumn Syntax ArgumentOption Break Column Compute Display TitleHeading headingtext ColumnnameFormat formatstring Character Description Date-Time Format Strings for the Column StatementChar Null ? Type Length ColnameNot Null INT Sysdate OrderinfoAmount Column Title FLDNEW Title ComputeVariablename AVG MAX MIN SUM CountValue Define SyntaxDisplayvalue ColpositionCOL columnnumber @columnnameEdit Syntax Exit Exit or Quit SyntaxRelated Statements Isql GET query.sql 10 GET SyntaxIsql RUN Help Syntax Help CommandsclausesHistory Syntax Orderstate LotlocationFollowing example illustrates usage of the History statement From HostcommandHost or SH or Syntax 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 INTDate TablenameType Length Colname Null ? 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 filesPosition not specified for fixed length record Compilation ErrorsRecord name redefined 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 CodeVARCHAR6 IntegerMoney 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