Filter
Top Products
FairCom Corporation 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