HP c-tree-SQL ISQL and Tools manual Tablename, Type Length Colname Null ?, Date

Page 67

				ISQL Statements

has_ccnstrs	NOT NULL		VARCHAR	1
has_ucnstrs	NOT NULL		VARCHAR	1
tbl_status	NOT	NULL	VARCHAR	1
rssid	NOT	NULL	INT	4

The following example uses the table command to detail the structure of the tables used in examples throughout this chapter.

ISQL> table	- List the sample tables
TABLENAME
---------
customers
lot_staging
lots
orders
quality
samples
ISQL> table customers		TYPE	LENGTH
COLNAME	NULL ?	TYPE	LENGTH
-------	------	----	------
customer_id	NOT NULL	INT	4
customer_name		CHAR	50
customer_street		CHAR	100
customer_city		CHAR	50
customer_state		CHAR	10
customer_zip		CHAR	5
ISQL> table orders		TYPE	LENGTH
COLNAME	NULL ?	TYPE	LENGTH
-------	------	----	------
order_id	NOT NULL	INT	4
customer_id		INT	4
steel_type		CHAR	20
order_info		CHAR	200
order_weight		INT	4
order_value		INT	4
order_state		CHAR	20
ISQL> table lots		TYPE	LENGTH
COLNAME	NULL ?	TYPE	LENGTH
-------	------	----	------
lot_id	NOT NULL	INT	4
order_id	NOT NULL	INT	4
lot_units		INT	4
lot_info		CHAR	200
ISQL> table lot_staging		TYPE	LENGTH
COLNAME	NULL ?	TYPE	LENGTH
-------	------	----	------
lot_id		INT	4
lot_location		CHAR	20
start_date		DATE
end_date		DATE	200
issues		CHAR	200
ISQL> table quality		TYPE	LENGTH
COLNAME	NULL ?	TYPE	LENGTH
-------	------	----	------

FairCom Corporation

3-41

Image 67

Contents For use with c-treeSQL Server Isql and Tools Reference GuidePage Table of Contents Data Load Utility dbload Iii Tutorial Source CodeFairCom Corporation Audience Syntax Diagram ConventionsDocumentation Overview Purpose of this ManualIsql and Tools Related DocumentationOverview IntroductionIsql and Tools FairCom Corporation Isql Quick TourIntroductory Tutorial InitIsql Commit Work Custmast DefineManage Isql Create Table 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 Arguments Isql StatementsStarting Interactive SQL SyntaxConnectstring PasswordStatement History Support UsernameStatement Summary Formatting Output of Isql QueriesIsql Statements Isql Statements for Statement History SupportDisplay 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 StatementsExample Isql Reference1 @ Execute Syntax DescriptionBreakspec Break SyntaxSkip n ExamplesCustomername History Clear SyntaxBreak Column Compute Display Title ArgumentColumn Syntax OptionFormat formatstring ColumnnameHeading headingtext Character Description Date-Time Format Strings for the Column StatementNot Null INT Null ? Type Length ColnameChar Amount OrderinfoSysdate Compute FLDColumn Title NEW TitleVariablename AVG MAX MIN SUM CountValue Define Syntax@columnname ColpositionDisplayvalue COL columnnumberEdit Syntax Related Statements Exit or Quit SyntaxExit Isql GET query.sql 10 GET SyntaxIsql RUN Orderstate Lotlocation Help CommandsclausesHelp Syntax History SyntaxFollowing example illustrates usage of the History statement Host or SH or Syntax HostcommandFrom List Syntax Isql History Quit or Exit Syntax16 RUN Syntax QuitLinesize Save Syntax18 SET Syntax PagesizePagesize numberlines TBL Connection databasename DefaultTransaction Isolation Level isolationlevel Isql Break on Isql Select TBL from Systables TBLShow Syntax Database Connections Is Default ?Spool Syntax Filename onIsql Spool OFF Start SyntaxArgument … Isql Spool STK onNot Null Varchar Null ? Type Length Colname Not Null INTType Length Colname Null ? TablenameDate Double Title SyntaxLeft Center Right COL n TextIsql Clear Title Isql and Tools FairCom Corporation Introduction Data Load Utility dbloadOptions Dbload Command Line SyntaxCommandsfile Prerequisites for DbloadData Load Utility dbload Data File FormatsNext Record Commands FileVariable Length Records Fixed Length RecordsChar 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 Username.triggername Username.procedurenameOutfile Username.tablenameEND Schema Export Utility dbschemaDbschema Import BeginIsql 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