CA Ramis only allows one HOLD file at a time
search cancel

CA Ramis only allows one HOLD file at a time

book

Article ID: 63210

calendar_today

Updated On:

Products

Ramis Reporter

Issue/Introduction

Use CA Ramis RELATE as one application solution to the CA Ramis limit of only one HOLD file at a time.

 

Environment

Release: 7.4 

CA Ramis
CA Ramis Reporter

Resolution

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     

 

Additional Information

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.