--  category:  IBM i Services for BRMS
--  description:  Application - BRMS Maintenance Policy Views
--  minvrm: V7R3M0
--  Requires BRMS PTFs - 7.5 SI82234, 7.4 SI82233, 7.3 SI82232
--  last updated: 3/15/2023
--
-- View all the maintenance policy fields
--
SELECT *
    FROM QUSRBRM.MAINTENANCE_POLICY;

--
-- View all ‘retain detail’ maintenance policy values:
--
SELECT RETAIN_OBJECT_DETAIL,
       RETAIN_LINK_DETAIL,
       RETAIN_SPLF_DETAIL,
       RETAIN_FOLDER_DETAIL
    FROM QUSRBRM.MAINTENANCE_POLICY;