Pagesize numberlines | HP c-tree-SQL ISQL and Tools instruction

ISQL Statements

	COMMAND LINES number_lines
	REPORT { ON	OFF	}
	ECHO { ON	OFF }
	PAUSE { ON	OFF }
	TIME { ON	OFF }	OFF }
	DISPLAY COST	{ ON	OFF }
	AUTOCOMMIT {	ON	OFF }
	TRANSACTION	ISOLATION LEVEL isolation_level
	CONNECTION {	database_name DEFAULT }

Description

The SET statement changes various characteristics of an interactive SQL session.

Arguments

HISTORY

Sets the number of statements that ISQL will store in the history buffer. The default is 1 state- ment and the maximum is 250 statements.

PAGESIZE number_lines

Sets the number of lines per page. The default is 24 lines. After each number_lines lines, ISQL executes any DISPLAY ON PAGE statements in effect and re-displays column headings. The PAGESIZE setting affects both standard output and the file opened through the SPOOL state- ment.

LINESIZE

Sets the number of characters per line. The default is 80 characters. The LINESIZE setting affects both standard output and the file opened through the SPOOL statement.

COMMAND LINES

Sets the number of lines to be displayed. The default is 1.

REPORT ON OFF

SET REPORT ON copies only the results of SQL statements to the file opened by the SPOOL filename ON statement. SET REPORT OFF copies both the SQL statement and the results to the file. SET REPORT OFF is the default.

ECHO ON OFF

SET ECHO ON displays SQL statements as well as results to standard output. SET ECHO OFF suppresses the display of SQL statements, so that only results are displayed. SET ECHO ON is the default.

PAUSE ON OFF

SET PAUSE ON prompts the user after displaying one page of results on the screen. SET PAUSE ON is the default.

TIME ON OFF

SET TIME ON displays the time taken for executing a database query statement. SET TIME OFF disables the display and is the default.

FairCom Corporation

3-35

Image 61

HP c-tree-SQL ISQL and Tools manual Pagesize numberlines

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 Documentation Overview Syntax Diagram ConventionsPurpose of this Manual Audience Isql and Tools Related Documentation Overview Introduction Isql and Tools FairCom Corporation Introductory Tutorial Quick TourInit Isql Manage DefineIsql Create Table Custmast Isql Commit Work Custmast Complete Introductory Tutorial Code DoneQuick Tour ISQLTutorial2.sql Relational Model and Indexing Tutorial Quick Tour Values Insert Into 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 Starting Interactive SQL Isql StatementsSyntax Arguments Statement History Support PasswordUsername Connectstring Isql Statements Formatting Output of Isql QueriesIsql Statements for Statement History Support Statement Summary 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 Ordervalue 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 Statements 1 @ Execute Syntax Isql ReferenceDescription Example Breakspec Break Syntax Skip n ExamplesCustomername History Clear Syntax Column Syntax ArgumentOption Break Column Compute Display Title Format formatstring ColumnnameHeading headingtext Character Description Date-Time Format Strings for the Column Statement Not Null INT Null ? Type Length ColnameChar Amount OrderinfoSysdate Column Title FLDNEW Title Compute Variablename AVG MAX MIN SUM Count Value Define Syntax Displayvalue ColpositionCOL columnnumber @columnname Edit Syntax Related Statements Exit or Quit SyntaxExit Isql GET query.sql 10 GET Syntax Isql RUN Help Syntax Help CommandsclausesHistory Syntax Orderstate Lotlocation Following example illustrates usage of the History statement Host or SH or Syntax HostcommandFrom List Syntax 16 RUN Syntax Quit or Exit SyntaxQuit Isql History 18 SET Syntax Save SyntaxPagesize Linesize Pagesize numberlines Transaction Isolation Level isolationlevel Connection databasename DefaultIsql Break on Isql Select TBL from Systables TBL TBL Show Syntax Spool Syntax Is Default ?Filename on Database Connections Argument … Start SyntaxIsql Spool STK on Isql Spool OFF Not Null Varchar Null ? Type Length Colname Not Null INT Type Length Colname Null ? TablenameDate Left Center Right COL n Title SyntaxText Double Isql Clear Title Isql and Tools FairCom Corporation Introduction Data Load Utility dbload Commandsfile Dbload Command Line SyntaxPrerequisites for Dbload Options Data Load Utility dbload Data File Formats Variable Length Records Commands FileFixed Length Records Next Record Char Short Long Float Double Define Record Statement Null For Each Statement Examples Example 4-1 Sample dbload commands files Record name redefined Compilation ErrorsPosition 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 Outfile Username.procedurenameUsername.tablename Username.triggername Dbschema Schema Export Utility dbschemaImport Begin END Isql and Tools FairCom Corporation Commit Work Select * from Custmast Delete from Custmast Tutorial Source Code Money IntegerVARCHAR6 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