Checking if a DISTID is in a list using the RMOGRW utility.

Products

• Deliver

Issue/Introduction

Is it  possible to check using RMOGRW  whether a DISTID is a part of a distribution list or not ?

So I can then query further on the reports a particular DISTID has listed.

For clarity, this is specifically to check if DISTID is a part of a list, not if the DISTID itself is a list. I'm aware of the field value DTYPE.

 

 

Environment

Release : 14.0

Resolution

Consider running the following RMOGRW reports to list out initial information regarding Distribution Lists and Distribution ID information

The following RMOGRW can  list the the DISTIDs associated with a Dist List 

/CONTROL SEQ=DID DATABASE= * HLQ of your Ca View database * 
/DEFINE I BIN                               
/IF DLIST = 'Y'                             
/  DO I = 1 TO LNDISTID BY 1                
/    PRINT DID 'DISTID LIST NAME' COL(1)    
/    PRINT LDISTID 'DISTID IN LIST' COL(35) 
/    NEXT LDISTID                           
/  END                                      
/END  

The following RMOGRW will list out the reports associated with a DISTID where that DISTID might also be defined in a Distribution List.  

It will list out the reports for OPS where OPS is defined in a DISTID List 

/IF LDISTID = 'OPS' OR DID = 'OPS' 
/ PRINT LDISTID                    
/ PRINT DID                        
/ PRINT RID                        
/END