zOs/SQL/PDBPKG2

  SELECT
      'RZ2'                              AS SSID
     ,LASTUSED                           AS LASTUSED
     ,PCK_ID                             AS PACKAGE
     ,PCK_CONSIST_TOKEN                  AS CONSISTENCY_TOKEN
    FROM RZ2.TACCT_PKGUSED -- RZ2
   WHERE
      (PCK_ID = 'YKSMODU'                                            )
   OR (PCK_ID = 'AADLTP'                                             )
   OR (PCK_ID = 'YKSMODU'                                            )
   OR (PCK_ID = 'YKSMODU'                                            )
   OR (PCK_ID = 'SA5140'                                             )
   OR (PCK_ID = 'YSA0231'                                            )
   OR (PCK_ID = 'YSA0232'                                            )
   OR (PCK_ID = 'YSA0233'                                            )
   OR (PCK_ID = 'YSA0234'                                            )
   OR (PCK_ID = 'YSA0235'                                            )
   OR (PCK_ID = 'YSA0236'                                            )
   OR (PCK_ID = 'YSX0610'                                            )
   OR (PCK_ID = 'YSXRELK'                                            )
   OR (PCK_ID = 'YSXRELK'                                            )
   ;
   X
   ;
                     'YBTMOR1',
                     'YBTMOR2',
                     'YBTMOR3',
                     'YNFCGO',
  SELECT
      'RZ2'                              AS SSID
     ,LASTUSED                           AS LASTUSED
     ,PCK_ID                             AS PACKAGE
     ,PCK_CONSIST_TOKEN                  AS CONSISTENCY_TOKEN
    FROM RZ2.TACCT_PKGUSED -- RZ2
   WHERE PCK_ID LIKE 'YBTM%'
   ;
                     'YBTMOR1',
                     'YBTMOR2',
                     'YBTMOR3',
                     'YNFCGO',
                     'YNFVMG',
                     'YYBTMMS')
      ;
      X
-- ZWECK:        WANN WURDE EIN PACKAGE ZULETZT BENUTZT
-- VERDICHTUNG:  PRO PACKAGE
-- ZEITRAUM:     AKTUELL
-- UNIQUE INDEX: PCK_ID, PCK_CONSIST_TOKEN
--
  SELECT
      'RZ1'                              AS SSID
     ,LASTUSED                           AS LASTUSED
     ,PCK_ID                             AS PACKAGE
     ,PCK_CONSIST_TOKEN                  AS CONSISTENCY_TOKEN
    FROM RZ1.TACCT_PKGUSED -- RZ1
   WHERE PCK_ID    = 'YBWAAJ9'
--   AND PCK_ID LIKE 'YNF%'
--   AND PCK_CONSIST_TOKEN    = '                   '
--   AND PCK_CONSIST_TOKEN LIKE '                   '

UNION

  SELECT
      'RZ2'                              AS SSID
     ,LASTUSED                           AS LASTUSED
     ,PCK_ID                             AS PACKAGE
     ,PCK_CONSIST_TOKEN                  AS CONSISTENCY_TOKEN
    FROM RZ2.TACCT_PKGUSED -- RZ2
   WHERE PCK_ID    = 'YBWAAJ9'
--   AND PCK_ID LIKE 'YNF%'
--   AND PCK_CONSIST_TOKEN    = '                   '
--   AND PCK_CONSIST_TOKEN LIKE '                   '

UNION

  SELECT
      'RR2'                              AS SSID
     ,LASTUSED                           AS LASTUSED
     ,PCK_ID                             AS PACKAGE
     ,PCK_CONSIST_TOKEN                  AS CONSISTENCY_TOKEN
    FROM RR2.TACCT_PKGUSED -- RR2 (PTA)
   WHERE PCK_ID    = 'YBWAAJ9'
--   AND PCK_ID LIKE 'YNF%'
--   AND PCK_CONSIST_TOKEN    = '                   '
--   AND PCK_CONSIST_TOKEN LIKE '                   '

UNION

  SELECT
      'RZ4'                              AS SSID
     ,LASTUSED                           AS LASTUSED
     ,PCK_ID                             AS PACKAGE
     ,PCK_CONSIST_TOKEN                  AS CONSISTENCY_TOKEN
    FROM RZ4.TACCT_PKGUSED -- RZ4
   WHERE PCK_ID    = 'YBWAAJ9'
--   AND PCK_ID LIKE 'YNF%'
--   AND PCK_CONSIST_TOKEN    = '                   '
--   AND PCK_CONSIST_TOKEN LIKE '                   '

UNION

  SELECT
      'RR4'                              AS SSID
     ,LASTUSED                           AS LASTUSED
     ,PCK_ID                             AS PACKAGE
     ,PCK_CONSIST_TOKEN                  AS CONSISTENCY_TOKEN
    FROM RR4.TACCT_PKGUSED -- RR4 (PTA)
   WHERE PCK_ID    = 'YBWAAJ9'
--   AND PCK_ID LIKE 'YNF%'
--   AND PCK_CONSIST_TOKEN    = '                   '
--   AND PCK_CONSIST_TOKEN LIKE '                   '