CA View - ERO Table Order

Products

• Deliver
• View

Issue/Introduction

The client sorted their ERO table and now receive errors in what retentions are applied to their reports. . 

Before ERO table sort:

/PR**D*   ALL RETPD=400 DCOPIES=7     

/PR**M*   ALL COPIES=24 DCOPIES=3     

/PR**Q*   ALL COPIES=24 DCOPIES=3     

/PR**W*   ALL COPIES=400 DCOPIES=3    

/PR**Y*   ALL COPIES=10 DCOPIES=3     

...

/PR*      ALL RETPD=365 DRETPD=5 LRETPD=14   

After ERO table sort:  

/PRM*     ALL COPIES=12 DCOPIES=3      

...

/PR**D*   ALL RETPD=400 DCOPIES=7           

/PR**M*   ALL COPIES=24 DCOPIES=3           

/PR**Q*   ALL COPIES=24 DCOPIES=3           

/PR**W*   ALL COPIES=400 DCOPIES=3          

/PR**Y*   ALL COPIES=10 DCOPIES=3           

/PR*      ALL RETPD=365 DRETPD=5 LRETPD=14  

Report PRMFD090 was assigned the wrong retention.

Environment

Release : 12.2

Component : CA View

Resolution

The client had sorted their ERO table, which caused problems.

There is a Warning made in the View Reference Guide, where it is said that the ERO table should not be sorted.

The client's sorted table, with some adjustments, was correct in-and-of-itself according to program's SARVERO logic.

From an ERO table review, the client would have possible problems with retentions applied with the reports that begin with DR..., PN..., and PR....

The reported report PRMFD090 was in that category.

As their table before sorting worked, the client was advised to set their table in this order:

/DR**M* ALL RETPD=360 DCOPIES=1
/DR**Q* ALL RETPD=90 DCOPIES=1
/DR**W* ALL COPIES=12 DCOPIES=1
...
/DRM* ALL COPIES=12 DCOPIES=1
/DRQ* ALL COPIES=12 DCOPIES=1
/DRW* ALL COPIES=12 DCOPIES=1
/DR* ALL COPIES=90 DCOPIES=1

/PN**D* ALL COPIES=90 DCOPIES=7
/PN**M* ALL COPIES=12 DCOPIES=3
/PN**Q* ALL COPIES=12 DCOPIES=3
/PN**W* ALL COPIES=12 DCOPIES=3
/PN**Y* ALL COPIES=10 DCOPIES=3
...
/PNM* ALL RETPD=370 DCOPIES=3
/PNQ* ALL COPIES=12 DCOPIES=3
/PNW* ALL COPIES=12 DCOPIES=3
/PNY* ALL COPIES=10 DCOPIES=3
/PN* ALL RETPD=365 DRETPD=5 LRETPD=14

/PR**D* ALL RETPD=400 DCOPIES=7
/PR**M* ALL COPIES=24 DCOPIES=3
/PR**Q* ALL COPIES=24 DCOPIES=3
/PR**W* ALL COPIES=400 DCOPIES=3
/PR**Y* ALL COPIES=10 DCOPIES=3
...
/PRM* ALL RETPD=180 DCOPIES=3
/PRQ* ALL RETPD=180 DCOPIES=3
/PRW* ALL RETPD=180 DCOPIES=3
/PRY* ALL COPIES=10 DCOPIES=3
/PR* ALL RETPD=365 DRETPD=5 LRETPD=14

The client was advised to do the following:

. Make a copy of your current table.
. Make the above adjustments to the entries.
. Run SARINIT, with EROPRO=ALL.
. Run SARVERO with PARM='view_hlq' (no TABLE), with the current table with the changes.

The results of SARVERO, not using the TABLE parameter, will show the results of the newly applied retentions.