PCFORMAT User's Guide

Tandem Database to 654X Application: A Complete Example
Operation
2–8 066374 Tandem Computers Incorporated
Note This example assumes the data needed for the 654X application is organized as required in
a database file. If this is not the case, add a new record to the dictionary (with DDL) and use
the ENFORM FIND command to create the new database file.
Figure 2-3. ENFORM LIST of CYCPARTS File
Part Part No. Location In Stock Reorder @ Cost Retail
---------------- ------- -------- -------- --------- ---- ------
Air Filter 4100 B332 103 10 2.50 4.85
Alternator 4822 A028 7 1 49.00 105.50
Battery (Mod XL) 3908 B678 12 2 28.00 45.00
Brake lever 1967 C012 21 4 12.00 20.95
Carburetor 3100 B321 3 2 101.00 239.49
Clutch 6390 A800 4 2 46.00 89.95
Footpeg (front) 6920 E163 29 5 4.00 9.95
Footpeg (rear) 8920 E173 36 5 4.50 10.95
Fuel cap 741 B341 9 1 8.50 15.45
Headlight 190 A892 8 1 46.50 74.95
Horn 3561 C123 41 8 11.50 19.95
Oil filter 9209 B333 204 25 1.95 3.75
Seat 1436 A254 18 3 70.00 120.00
Sidestand 9874 F410 17 2 9.00 16.75
Spark plug 5555 B826 103 10 .89 1.95
Speedometer 258 D542 13 2 18.00 39.95
Tachometer 264 D381 29 2 17.50 42.95
Tire (front) 1012 G003 22 6 61.00 95.00
Tire (rear) 1028 G008 14 10 65.00 115.00
Tool kit 9999 A035 13 2 17.00 33.50
5. Now that the database file to be used by Lotus 1-2-3 and its associated
record have been checked, it’s time to use PCFORMAT.
Lotus 1-2-3 can use two of the output formats from PCFORMAT: either
DIF or BASIC. With the DIF format, a translate utility must be used
first to convert the data to a worksheet file. The BASIC format, which is
the same as the print file format in Lotus 1-2-3, can be used directly