SM37 Jobs mit SQL-Mitteln ausgeben

SELECT jobname,
         sdluname,
         TO_DATE (SDLDATE || SDLTIME, 'yyyymmddhh24miss') "PLANZEITPUNKT",
         strtdate,
         strttime,
         enddate,
         endtime,
         CASE
            WHEN STATUS = 'R' THEN 'Aktiv'
            WHEN STATUS = 'Y' THEN 'Bereit'
            WHEN STATUS = 'P' THEN 'Geplant'
            WHEN STATUS = 'S' THEN 'Freigegeben'
            WHEN STATUS = 'A' THEN 'Abgebrochen'
            WHEN STATUS = 'F' THEN 'Fertig'
            WHEN STATUS = 'Z' THEN 'freig./susp.'
            WHEN STATUS = 'X' THEN 'Unbekannt'
            ELSE 'Unbekannt'
         END
            "STATUS"
    FROM tbtco
   WHERE TO_DATE (SDLSTRTDT || SDLSTRTTM, 'yyyymmddhh24miss') > SYSDATE - 1
ORDER BY TO_DATE (SDLSTRTDT || SDLSTRTTM, 'yyyymmddhh24miss')

SELECT jobname, sdluname, TO_DATE (SDLDATE || SDLTIME, 'yyyymmddhh24miss') "PLANZEITPUNKT", strtdate, strttime, enddate, endtime, CASE WHEN status = 'R' THEN 'Aktiv' WHEN status = 'Y' THEN 'Bereit' WHEN status = 'P' THEN 'Geplant' WHEN status = 'S' THEN 'Freigegeben' WHEN status = 'A' THEN 'Abgebrochen' WHEN status = 'F' THEN 'Fertig' WHEN status = 'Z' THEN 'freig./susp.' WHEN status = 'X' THEN 'Unbekannt' ELSE 'Unbekannt' END "STATUS" FROM tbtco WHERE TO_DATE (SDLSTRTDT || SDLSTRTTM, 'yyyymmddhh24miss') > SYSDATE - 1 ORDER BY TO_DATE (SDLSTRTDT || SDLSTRTTM, 'yyyymmddhh24miss')