loading already existing tables with add load

[#1]

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

[Miguel_Angel_Baeyens]

Hello Ingo,

I may be wrong according to your code sample but you must first load your table and then create a new one loading with "RESIDENT".

Hope that helps.

[#3]

Hi,

if you load the Script, then he saved the actuall version, i wanted only to make an "update" of these data with the help of an timestamp

OLDLASTOCCURENCE is the timestamp from the actually loaded data and i wanted only to load the data with Select where the Firstoccurence timestamp is newer than the oldlastoccurence