Manuals / HP / Computer Equipment / Printer

HP c-tree-SQL ISQL and Tools manual Data Unload Utility dbdump, Short Long Float Double

Models: c-tree-SQL ISQL and Tools

1 99

Download 99 pages 4.83 Kb

Page 83

Data Unload Utility: dbdump

The syntax definition for the commands file is as shown:

dbdump_commands: define_record_statement for_record_statement

The following is sample commands file showing dump instructions.

DEFINE RECORD ord_rec AS

( ord_no, item_name, date, item_qty ) FIELD DELIMITER ' ' ;

FOR RECORD ord_rec dump into ord_dat

USING SELECT order_no, product, order_date, qty

FROM items;

5.5.1The DEFINE RECORD Statement

The DEFINE RECORD statement is used to define the record of the output file. The following are the definitions that are made known by the DEFINE RECORD statement:

•Names the record of the output file

•Names the fields of the record

•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,

...

)

]

[ 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.

FairCom Corporation

5-3

Image 83

HP c-tree-SQL ISQL and Tools manual Data Unload Utility dbdump, Short Long Float Double

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 Quick Tour DoneComplete Introductory Tutorial Code ISQLTutorial2.sql Relational Model and Indexing Tutorial Quick Tour Values Insert IntoValues Insert Into 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 Customername 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 Statements Example Isql Reference1 @ Execute Syntax Description Breakspec Break Syntax Customername ExamplesSkip n History Clear Syntax Break Column Compute Display Title ArgumentColumn Syntax Option Heading headingtext ColumnnameFormat formatstring Character Description Date-Time Format Strings for the Column Statement Char Null ? Type Length ColnameNot Null INT Sysdate OrderinfoAmount Compute FLDColumn Title NEW Title Variablename AVG MAX MIN SUM Count Value Define Syntax @columnname ColpositionDisplayvalue COL columnnumber Edit Syntax Exit Exit or Quit SyntaxRelated Statements Isql GET query.sql 10 GET Syntax Isql RUN Orderstate Lotlocation Help CommandsclausesHelp Syntax History Syntax Following example illustrates usage of the History statement From HostcommandHost or SH or Syntax 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 Date TablenameType Length Colname Null ? 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 Position not specified for fixed length record Compilation ErrorsRecord name redefined 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 VARCHAR6 IntegerMoney 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