Hallo Frau Hauser,

ist es auch möglich im Select-Statement mehrere Dateien anzugeben?
Bekomme den Fehler SQL0511.

Code:
EXEC SQL
 DECLARE CUR_C1 CURSOR FOR
 SELECT T01.FIRMA, T01.PENR, T02.NAME
      , T03.FELD1, T03.FELD2, T03.FELD3, 
        T04.FELD1
 FROM   FILE01 T01
        INNER JOIN FILE04 T04
     ON T04.LND    = T01.LND
    AND T04.MONAT = T01.MONAT
    AND T04.FIRMA       = T01.FIRMA
    AND T04.PENR       = T01.PENR
        INNER JOIN FILE02 T02
     ON T02.IDP       = T01.IDP
    AND T02.LND    = T01.LND
    AND T02.MONAT = T01.MONAT
        INNER JOIN FILE03 T03
     ON T03.LND    = T01.LND
    AND T03.MONAT = T01.MONAT
    AND T03.FIRMA       = T01.FIRMA
    AND T03.PENR       = T01.PENR
 ORDER BY T01.LND , T01.FIRMA , T01.PENR
        , T01.MONAT
FOR UPDATE OF Feld1, Feld2, Feld3
lg