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