HP c-tree-SQL ISQL and Tools manual Define Record Statement, Char Short Long Float Double

Page 75

Data Load Utility: dbload

4.5.1The DEFINE RECORD Statement

The DEFINE RECORD statement is used to define the record that is to be loaded into the data- base. It describes the data found in the data file. The following are the definitions that are made known by the DEFINE RECORD statement:

•Names the record to be loaded

•Names the fields of the record to be loaded as found in the data file

•Specifies whether the records in the data file are variable length records or fixed length records

•If fixed length records, specifies the position and data type of the field

The following is the syntax definition of the DEFINE RECORD statement:

DEFINE RECORD record_name

[ OF FIXED LENGTH record_length AS (

field_name position_specification type_specification, ...

)

]

AS (

field_name, ...

)

[ FIELD DELIMITER delimiter_char ]

[ RECORD DELIMITER delimiter_string ] ;

position_specification::

POSITION ( start_position : end_position )

type_specification::

CHAR

SHORT

LONG

FLOAT

DOUBLE

The following are the variable descriptions of the DEFINE RECORD syntax:

•record_name is the name used to refer to the records found in the data file.

•record_length is the length of the fixed length record. This length should include the length of field or record delimiters, if any.

•field_name is the name used to refer to a field in the data file.

•delimiter_char is the field delimiter and is a single character. It must be specified as a lit- eral.

•delimiter_string is the record delimiter and can be a single character or a string. It must be specified as a literal.

FairCom Corporation

4-5

Image 75

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 CustmastDone Complete Introductory Tutorial CodeQuick Tour ISQLTutorial2.sql Relational Model and Indexing TutorialQuick Tour Insert Into Values 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 StatementExample 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 StatementsExample Isql Reference1 @ Execute Syntax DescriptionBreakspec Break SyntaxExamples Skip nCustomername History Clear SyntaxBreak Column Compute Display Title ArgumentColumn Syntax OptionColumnname Format formatstringHeading headingtext Character Description Date-Time Format Strings for the Column StatementNull ? Type Length Colname Not Null INTChar Orderinfo AmountSysdate Compute FLDColumn Title NEW TitleVariablename AVG MAX MIN SUM CountValue Define Syntax@columnname ColpositionDisplayvalue COL columnnumberEdit Syntax Exit or Quit Syntax Related StatementsExit Isql GET query.sql 10 GET SyntaxIsql RUN Orderstate Lotlocation Help CommandsclausesHelp Syntax History SyntaxFollowing example illustrates usage of the History statement Hostcommand Host or SH or SyntaxFrom 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 INTTablename Type Length Colname Null ?Date 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 filesCompilation Errors Record name redefinedPosition 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 CodeInteger MoneyVARCHAR6 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