2 Replies Latest reply: Jun 16, 2010 10:22 AM by Ingo-Placzek RSS

    loading already existing tables with add load

    Ingo-Placzek

       

       

       

       

       

      hi, i would like to load an already existing table but he told me that it doesn't exists.



      add load

      Max(Status.LASTOCCURRENCE) as oldLASTOCCURRENCE

      resident Status;

       

      Status:

      SQL SELECT
      ...

      FROM TG01885."REPORTER_STATUS"

      where FIRSTOCCURRENCE >= $(OLDLASTOCCURRENCE);

      best regards
      Ingo Placzek