zOs/SQL/TV

  CREATE VIEW S100447.VrtsReoTSException AS
      SELECT PRIO, db, ts,
          PARTVON, PARTBIS, GUVON, GUBIS,
          reorg, unclust, farindref, nearindref, extents, reorgdays,
          inserts, updates, deletes,
          inserttimestamp, remark,
          CASE WHEN POSSTR(DB,  '*') > 0
               THEN POSSTR(DB,  '*') - 1 ELSE 8 END DBLEN,
          CASE WHEN POSSTR(TS,  '*') > 0
               THEN POSSTR(TS,  '*') - 1 ELSE 8 END TSLEN,
          char(RIGHT('0' || STRIP(CHAR(PRIO)), 2)
              || strip(DB) || case when POSSTR(DB, '*') > 0
                                   then '' else '=' end
              || strip(ts) || case when POSSTR(ts, '*') > 0
                                   then '' else '=' end
              || right('0000' || strip(char(partVon)), 4)
              || '.' || translate('34679A', char(GUVON, ISO),
                                                   '123456789A')
              , 31) KEY
      FROM S100447.TrtsReoTSException ;
    commit;
  COMMENT ON table S100447.VrtsReoTSException
    IS 'diese Tabelle enthaelt die Default-Schwellwerte und die TS mit s
peziellen Schwellwerten für RTS-Reorgs.'
;
  LABEL ON S100447.VrtsReoTSException
    ( PRIO                is 'Prioritaet: tiefste=0=Default' ,
      DB                  is 'Datenbank Name'                ,
      TS                  is 'TableSpace Name'               ,
      TSLEN               is 'Laenge Datenbank Name'         ,
      PARTVON             is 'Partition von'  ,
      PARTBIS             is 'Partition bis'  ,
      GUVON               is 'Gueltig von'                   ,
      GUBIS               is 'Gueltig bis'                   ,
      REORG               is 'ALWAYS,NEVER,THRESHOLD'        ,
      UNCLUST             is 'Schwellwert unclustered %'     ,
      FARINDREF           is 'SchwWe overflow far (>16 pg) %',
      NEARINDREF          is 'SchwWe overflow near(<16 pg) %',
      EXTENTS             is 'SchwWe Extents pro TS/Part'    ,
      REORGDAYS           is 'Schwellwert Anzahl Tage'       ,
      INSERTS             is 'Schwellwert inserts %'         ,
      UPDATES             is 'Schwellwert updates %'         ,
      DELETES             is 'Schwellwert deletes %'         ,
      INSERTTIMESTAMP     is 'Erstellungs Zeitpunkt'         ,
      REMARK              is 'Begründung (Freitext)'         ,
      DBLEN               is 'Laenge Datenbank Name'         ,
      TSLEN               is 'Laenge Datenbank Name'         ,
      KEY                 is 'eindeutiger Schluessel'
    ) ;