Fin "orphaned" Journal Receivers

find_orphaned_JRNRCV

SELECT Jr.Journal_Receiver_Library,Jr.Journal_Receiver_Name,Jr.Size
       ,Jr.Descriptive_Text,Jr.Journal_Library,Jr.Journal_Name     
       ,Jr.Attach_Timestamp,Jr.Detach_Timestamp                    
    FROM Qsys2.Journal_Receiver_Info Jr                            
    WHERE NOT EXISTS (SELECT J.Journal_Name                        
      FROM Qsys2.Journal_Info J                                    
        WHERE J.Journal_Library = Jr.Journal_Library               
          AND J.Journal_Name    = Jr.Journal_Name)                 
;