Introduction to ENFORM

Contents
iv 058051 Tandem Computers Incorporated
Building the Target File 3-5
Report Writing 3-7
Section 4 Using ENFORM to Produce Complete Reports
Starting ENFORM 4-3
Opening a File 4-3
Listing Information From a File Onto a Report 4-4
Listing Parts of a File 4-5
Sorting a File Listing 4-6
Restricting the Information that Appears on a Report 4-7
Connecting Files 4-9
Connecting Files By Using the Where Clause 4-9
Using the LINK Statement to Connect Files 4-10
Controlling the Appearance of the Report 4-11
Specifying Column Headings 4-12
Using the HEADING Clause to Specify Headings 4-13
Using DDL to Establish Default Headings 4-13
Using the CENTER Clause to Center Items within a Column 4-13
Using the SPACE Clause to Control Spacing Between Columns 4-14
Specifying Report Arithmetic 4-15
Using the TOTAL and SUBTOTAL Clause 4-16
Using the Arithmetic Expression Clauses 4-18
Using Aggregate Clauses 4-19
Index Index–1
Figures
Figure 1-1 Data Retrieval 1-1
Figure 1-2 Relational View of Data 1-3
Figure 1-3 Relating Information in a Relational Database 1-4
Figure 1-4 Online Transaction Processing Applications 1-5
Figure 1-5 ENFORM in an Online Transaction Processing
Environment 1-7
Figure 1-6 Data Dictionary 1-8
Figure 1-7 ENFORM Environment 1-9
Figure 1-8 Generating Compiled Queries 1-10