zOs/SQL/GRUPP1

UPDATE OA1A.TTN170A1 A
    SET   TICKER_ID =
        (SELECT SUBSTR(VALUE,10,4)
              FROM OA1A.TTN990A1
                  WHERE PGM = 'OTXSQL5P'
                      AND SETTING_NAME = 'INDEXTICKER'
                      AND SUBSTR(VALUE,20,2) = '01')
    WHERE A.DELETE_FLAG = 'X'
        AND A.INSTR_KEY IN
        (SELECT B.INSTR_KEY FROM OA1A.TTN100A1 B
             WHERE B.VALORENSTAMMNUMMER = (SELECT SUBSTR(VALUE,1,9)
             FROM OA1A.TTN990A1
             WHERE PGM = 'OTXSQL5P'
                 AND SETTING_NAME = 'INDEXTICKER'
                 AND SUBSTR(VALUE,20,2) = '01')
        AND B.DELETE_FLAG = '0')
;
FEHLER
;
SELECT COUNT(*), DELETE_FLAG
    FROM OA1A.TTN100A1 B
    GROUP BY DELETE_FLAG
;
SELECT COUNT(*), DELETE_FLAG
    FROM OA1A.TTN170A1 A
    GROUP BY DELETE_FLAG
;