SAS/ACCESS Interface to SYSTEM 2000 Data Management Software: Reference

Database Files

SYSTEM 2000 software has eight database files associated with each database. The first six are required files.

File 1 - Master Record and Definition Table
File 2 - Distinct Values Table
File 3 - Extended Field Table
File 4 - Multiple Occurrence Table
File 5 - Hierarchical Table
File 6 - Data Table
File 7 - Update Log (optional)
File 8 - Rollback Log (optional)

When you are working in a single-user environment, you must allocate the appropriate database files in your SAS session prior to accessing the data. For a Multi-User environment, the database files can be allocated before the Multi-User software is initialized or (Release 12.0 and later) the files can be dynamically allocated during execution using the ALLOC command.

Chapter Contents
Previous
Next
Top of Page