Edit Syntax, Fld | HP c-tree-SQL ISQL and Tools instruction

ISQL Statements

ISQL> display col 5 "Number of orders placed by", customer_name, "=", n_ord on customer_name

ISQL> compute count of order_id in n_ord on customer_name;

ISQL> select c.customer_name, o.order_id from customers c, orders o where o.customer_id = c.customer_id;

CUSTOMER_NAME		ORDER_ID
-------------		--------
Sports Cars Inc.		1
Sports Cars Inc.		2
Number of orders placed by Sports Cars Inc.
=	2
Mighty Bulldozer Inc.		3
Mighty Bulldozer Inc.		4
Number of orders placed by Mighty Bulldozer Inc.

=2

Ship Shapers Inc.		5
Ship	Shapers Inc.	6
Ship	Shapers Inc.	7
	Number of orders placed by Ship Shapers Inc.

=3

Tower Construction Inc.			8
Tower	Construction	Inc.	9
Tower	Construction	Inc.	10
	Number of orders placed by Tower Construction Inc.

=3

If the select-list of a query includes column titles, they override DISPLAY statements that include variable or column_name display values for those columns:

ISQL> display col 5 "test display. Sum of fld is", tmp on fld;

ISQL> compute sum of fld in tmp on fld;

ISQL> break on fld	-- This works:
ISQL> select fld from syscalctable;	-- This works:
FLD
---
100	100
test display. Sum of fld is	100
1 record selected

ISQL> select fld "column title" from syscalctable; -- DISPLAY is disabled:

COLUMN TITLE

------------

100

1 record selected

3.7.8EDIT

Syntax

E[DIT] [stmt_num];

Description

The EDIT statement invokes a text editor to edit the specified statement from the statement his- tory buffer. If the statement number is not specified, the last statement in the history buffer is

FairCom Corporation

3-25

Image 51

HP c-tree-SQL ISQL and Tools manual Edit Syntax, Fld

Contents

For use with c-treeSQL Server Isql and Tools Reference GuidePage Table of Contents Data Load Utility dbload Iii Tutorial Source Code FairCom Corporation Audience Syntax Diagram ConventionsDocumentation Overview Purpose of this Manual Isql and Tools Related Documentation Overview Introduction Isql and Tools FairCom Corporation Isql Quick TourIntroductory Tutorial Init Isql Commit Work Custmast DefineManage Isql Create Table Custmast Done Complete Introductory Tutorial CodeQuick Tour ISQLTutorial2.sql Relational Model and Indexing Tutorial Quick Tour Insert Into Values Insert IntoValues QTY Price Commit Work Complete 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 Tutorial Transaction Rollback Work Complete Transaction Processing Tutorial Source Code Arguments Isql StatementsStarting Interactive SQL Syntax Connectstring PasswordStatement History Support Username Statement Summary Formatting Output of Isql QueriesIsql Statements Isql Statements for Statement History Support Display Isql Statements for Query Formatting Summary Customername Customercity Orderid Ordervalue Example 3-1 Unformatted Query Display from Isql Example 3-2 Controlling Display Width of Character Columns Formatting Column Display with the Column Statement Example 3-3 Customizing Format of Numeric Column Displays OrdervalueCustomername 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 Statements Example Isql Reference1 @ Execute Syntax Description Breakspec Break Syntax Examples Skip nCustomername History Clear Syntax Break Column Compute Display Title ArgumentColumn Syntax Option Columnname Format formatstringHeading headingtext Character Description Date-Time Format Strings for the Column Statement Null ? Type Length Colname Not Null INTChar Orderinfo AmountSysdate Compute FLDColumn Title NEW Title Variablename AVG MAX MIN SUM Count Value Define Syntax @columnname ColpositionDisplayvalue COL columnnumber Edit Syntax Exit or Quit Syntax Related StatementsExit Isql GET query.sql 10 GET Syntax Isql RUN Orderstate Lotlocation Help CommandsclausesHelp Syntax History Syntax Following example illustrates usage of the History statement Hostcommand Host or SH or SyntaxFrom List Syntax Isql History Quit or Exit Syntax16 RUN Syntax Quit Linesize Save Syntax18 SET Syntax Pagesize Pagesize numberlines TBL Connection databasename DefaultTransaction Isolation Level isolationlevel Isql Break on Isql Select TBL from Systables TBL Show Syntax Database Connections Is Default ?Spool Syntax Filename on Isql Spool OFF Start SyntaxArgument … Isql Spool STK on Not Null Varchar Null ? Type Length Colname Not Null INT Tablename Type Length Colname Null ?Date Double Title SyntaxLeft Center Right COL n Text Isql Clear Title Isql and Tools FairCom Corporation Introduction Data Load Utility dbload Options Dbload Command Line SyntaxCommandsfile Prerequisites for Dbload Data Load Utility dbload Data File Formats Next Record Commands FileVariable Length Records Fixed Length Records Char Short Long Float Double Define Record Statement Null For Each Statement Examples Example 4-1 Sample dbload commands files Compilation Errors Record name redefinedPosition not specified for fixed length record Fatal Errors Isql and Tools FairCom Corporation Prerequisites for Dbdump Data Unload Utility dbdump Dbdump Command Line Syntax Short Long Float Double Data Unload Utility dbdump For Record Statement Define Record custrec of Fixed Length 37 AS Isql and Tools FairCom Corporation Schema Export Utility dbschema Username.triggername Username.procedurenameOutfile Username.tablename END Schema Export Utility dbschemaDbschema Import Begin Isql and Tools FairCom Corporation Commit Work Select * from Custmast Delete from Custmast Tutorial Source Code Integer MoneyVARCHAR6 Commit Work Delete from Custmast Tutorial Source Code Imdesc VARCHAR48 Select * from orderlist Select * from orderitems Isql and Tools FairCom Corporation Index-i Symbols Index-ii FairCom Corporation Isql Index-iii FairCom Corporation Index