You can store ROC Report output in either system files or in the database.
ROC output to the database might provide improved performance over output to a system file, due to reduced file open/close overhead. This is particularly noticeable on small files.
ROC output to a system file might provide improved performance over output to your database, due to reduced database activity overhead. This is more noticeable on larger files.
Choosing Output Storage
You specify your choice by using the ROC Uses Database segment configuration property (to provide a default value for all Reports) and the ROC Uses Database Report configuration property (for specific Reports) of Builder.
Using the Segment Configuration Properties Under the Environment Category
You select a default storage method for all Reports by setting to True the ROC Uses Database Segment configuration property under the Environment category. The property settings are interpreted in the following table.
You select a default storage method for all Reports by setting to True the ROC Uses Database Segment configuration property under the Environment category. The property settings are interpreted in the following table.
| Value | Output Storage Method |
|---|---|
| True | ROC Database |
| False | System file (default for new and existing Systems) |
Using the Report Configuration Properties Under the Environment Category
You select a storage method for a specific Report by y setting to True the ROC Uses Database Report configuration property under the Environment category. The property settings are interpreted in the following table:
| Value | Output Storage Method |
|---|---|
| True | ROC Database (default for existing Reports in migrated Systems) |
| False | System file (default for new and existing Reports) |
About System Files
System files are maintained in the same format as ROC output to your database, to optimize access. The output for each report is stored in a separate system file. System data files are named as follows:
system/ROCDATA/nnnnnnnn ON pack
The nnnnnnnn value represents the ROC Report number, and pack the ROC pack.