zOs/SQL/GRUPP0

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