Use CA Ramis RELATE as one application solution to the CA Ramis limit of only one HOLD file at a time.
Release: 7.4
CA Ramis
CA Ramis Reporter
In a CA Ramis session, each HOLD will overwrite the previous HOLD data.
If you need to retain multiple results of report output data for further use within the session, one solution is to use RELATE with a single projection to "hold" the data instead of HOLD.
Since with RELATE, you specify the name of the RELATE file ("relation") to be created (with the NAMED or REPLACING phrase), any number of single projection RELATEs can be run.
The following example shows using HOLD and then using RELATE to report and "hold" the same data.
This example uses the STORE file for illustration.
The HOLD request is...
TABLE FILE STORE PRINT FILE AND ALIAS AND HOLD BY BLOCKS END
The equivalent RELATE request is...
RELATE PROJECT STORE USING EACH FILE AND ALIAS BY BLOCKS KEEP PROJECTION1 REPLACING REL1 END
Reminder that the ALIAS names are different when using HOLD and RELATE.
The ALIAS names for the HOLD data are Enn:
? HOLD command shows the definition of the resulting HOLD request as...
DESCRIPTION OF HOLD FILE
FIELD NAME ALIAS FORMAT
BLOCKS E01 I6
FILENAME E02 A12
ALIAS E03 A12
While, the ALIAS names for the RELATE data are Pn.
? RELATION REL1 command shows the definition of the resulting RELATION named REL1 as...
FIELDNAME ALIAS FORMAT
------------ ----- ------
BLOCKS P1 I6
FILENAME P2 A12
ALIAS P3 A12
The CA Ramis Version 7.4 set of documentation can be found at CA Ramis Bookshelves and PDFs.
Refer to Guide to CA-Ramis Reporting guide.
Refer to RELATE guide.