HP c-tree-SQL ISQL and Tools manual Tutorial Source Code, Iii

5.4 Data File Formats . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-2

5.5 The Commands File . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-2

5.5.1 The DEFINE RECORD Statement. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-3

5.5.2 The FOR RECORD Statement . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-4

5.6 Examples. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-4

6 Schema Export Utility: dbschema

6.1 Introduction. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6-1 6.2 Examples. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6-2

A Tutorial Source Code

A.1 Introductory Tutorial . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .A-1

A.2 Relational Model and Indexing Tutorial . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .A-1

A.3 Locking Tutorial . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .A-3

A.4 Transaction Processing Tutorial. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .A-3

Index	Index-i
List of Figures
Figure 4-1: dbload Execution Process	4-2
Figure 5-1: dbdump Execution Process	5-1
List of Tables
Table 3-1: ISQL Statements for Statement History Support	3-2
Table 3-2: ISQL Statements for Query Formatting	3-4
Table 3-3: Numeric Format Strings for the COLUMN Statement	3-18
Table 3-4:Date-Time Format Strings for the COLUMN Statement	3-18
List of Examples
Example 3-1: Unformatted Query Display from ISQL	3-5
Example 3-2: Controlling Display Width of Character Columns	3-6
Example 3-3: Customizing Format of Numeric Column Displays	3-7
Example 3-4: Specifying Column Breaks and Values with DISPLAY	3-8
Example 3-5: Calculating Statistics on Column Breaks with COMPUTE	3-9
Example 3-6: Specifying a Query Header and Footer with TITLE	3-10
Example 3-7: Sample ISQL script	3-12
Example 4-1: Sample dbload commands files	4-7

FairCom Corporation iii