View - ERO Table Order

Products

• 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.

Cause

The client had sorted their ERO table, which caused the problems. There is a warning made in the View Reference Guide, where it is said that the ERO table should not be sorted.

Resolution

From the ERO table review, it was found that possible problems with retentions applied with the reports that begin with DR..., PN..., and PR....

The reported report PRMFD090 was in that category.

As the ERO table before sorting worked fine, It is recommended that the table be set in the following 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 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.