SQLRPGLE - Select ... where xxfeld in( ??)

[selli]

ohhhhhhhhhhh


habs vertauscht und siehe da ...

es funktioniert .. herzlichen Dank

C/EXEC SQL
C+ DECLARE SQLDaten2 CURSOR FOR
C+ SELECT DISTINCT OFMDNR, OFHANR, OFOFNR, OFLEIA
C+ FROM OFAD03
C+ WHERE OFMDNR=:OSMDNR and
C+ OFHANR=:OSHANR and
C+ OFOFNR=:OSOFNR and
C+ POSSTR(:M1OUNR, CHAR(DIGITS(OFOUNR)) CONCAT ';') > 0 and
C+ POSSTR(:M1ZONE, CHAR(DIGITS(OFZONE)) CONCAT ';') > 0 and
C+ OFDTBI=0 and
C+ OFSAAK='J'
C+ GROUP BY OFMDNR, OFHANR, OFOFNR, OFLEIA
C+ ORDER BY OFMDNR, OFHANR, OFOFNR, OFLEIA


Vielen vielen Dank