zOs/SQL/SQLPARM

SELECT *
    FROM SSXX28Q0.DB2_BIND_PARMS
  --WHERE PGM LIKE 'PC0580I%'
    WHERE PGM LIKE 'YPC0760%'
  --WHERE PGM LIKE 'YPC0580%'
  --      AND COLLID = 'AV01' AND QUALIFIER LIKE '%02%'
;
INSERT INTO SSXX28Q0.DB2_BIND_PARMS
         (  APPL          ,
            RZ            ,
            PGM           ,
            SSID          ,
            "COLLID"      ,
            LOCATION      ,
            OWNER         ,
            QUALIFIER     ,
            ISOLATION     ,
            EXPLAIN       ,
            CURRENTDATA   ,
            "RELEASE"     ,
            DBPROTOCOL    ,
            DEGREE        ,
            DYNAMICRULES  ,
            KEEPDYNAMIC   ,
            REOPT         ,
            OPTHINT       ,
            IMMEDWRITE    ,
            FLAG
         )
    SELECT
            APPL          ,
            RZ            ,
            'YPC0760'     ,
            SSID          ,
            "COLLID"      ,
            LOCATION      ,
            OWNER         ,
            QUALIFIER     ,
            ISOLATION     ,
            EXPLAIN       ,
            CURRENTDATA   ,
            "RELEASE"     ,
            DBPROTOCOL    ,
            DEGREE        ,
            DYNAMICRULES  ,
            KEEPDYNAMIC   ,
            REOPT         ,
            OPTHINT       ,
            IMMEDWRITE    ,
            FLAG
    FROM SSXX28Q0.DB2_BIND_PARMS
    WHERE PGM = 'YPC0580';
    COMMIT;
SELECT *
    FROM SSXX28Q0.DB2_BIND_PARMS
  --WHERE PGM LIKE 'PC0580I%'
    WHERE PGM LIKE 'YPC0760%'
  --WHERE PGM LIKE 'YPC0580%'
  --      AND COLLID = 'AV01' AND QUALIFIER LIKE '%02%'
;
XELECT DISTINCT  COLLID, SUBSTR(QUALIFIER,5 ,2)
    FROM SSXX28Q0.DB2_BIND_PARMS
    WHERE PGM LIKE 'YAV0%'
;
SELECT COUNT(*), PGM
    FROM SSXX28Q0.DB2_BIND_PARMS
    WHERE PGM LIKE 'YAV0%'
    GROUP BY PGM
    ORDER BY PGM
;
SELECT COUNT(*), PGM, RZ, SSID
    FROM SSXX28Q0.DB2_BIND_PARMS
    WHERE PGM LIKE 'YAV0%'
    GROUP BY PGM, RZ, SSID
    ORDER BY PGM, RZ, SSID
;