Hi ,
Leider geht es immer noch nicht.

Hier mal das Statement

Wie gesagt, bei uns mit 5.2 lauft es

update &LIB/HJHUP HJH set HJH111 = coalesce(
(select substr(MN6.N6REF2, 1, 10) from &LIB/VO1H1 VO1
inner join &LIB/MN6 MN6 on VO1.VO1021 = MN6.N6LOPD
where HJH.HJH100 = VO1.VO1043 and
HJH.HJH203 = VO1.VO1052 and
HJH.HJH033 = VO1.VO1006 and
MN6.N6phas = '3' and
VO1.VO1034 = '*' and
VO1.VO1035 = '*' and
VO1.VO1023 <> 0), ' ')

where HJH.HJH015 = 'OBV' and
HJH.HJH100 = 'V' and
HJH.HJH203 > 0 and
HJH.HJH033 <> ' ' and
HJH.HJH074 not in ('1 ', '2 ', '3 ', '4 ', '5 ', '6 ', '7 ') and
HJH.HJH111 = ' ' and
HJH.HJH010 = 2003 and
HJH.HJH011 >= 09


Robi