Listing out Reports per Distribution ID in Deliver

Products

• Deliver

Issue/Introduction

Have a requirement to list Distribution IDs in Deliver with the Reports that they are defined to and a Report count.

Resolution

The Deliver Batch Reporting utility RMORPT ,specifically Report 4 ,can be used to generate a listing of Reports per Distribution ID 

More details can be found here  Deliver RMORPT Batch Reporting Utility

The RMOGRW General Report Writer can also be used to create such information 

The following RMOGRW example will list of Reports per selected Distribution id in Deliver and provide a Report Count  : - 

/CONTROL SEQ=RID DATABASE= Your DB HLQ
/DEFINE (J,K,L) BIN                     
/DEFINE CNT BIN                         
/DO J = 1 TO NRID BY 1                  
/ SET K = NRID                          
/ IF NDISTID NE 0                       
/ DO L = 1 TO NDISTID BY 1              
/ IF SUBSTR(DID,1,10) = 'nnnnnnn' where nnnnnnn is DISTID      
/ PRINT RID COL(1)                      
/ PRINT DID COL(33)                     
/ SET CNT = CNT+1                       
/ NEXT DID                              
/ END                                   
/ END                                   
/ END                                   
/ IF J = K                              
/ BREAK                                 
/ ELSE                                  
/ NEXT RID                              
/ END                                   
/END                                    
/ON ENDDATA                             
/   PRINT 'TOTAL REPORTS='||CNT COL(50) 
/END