Incremental Load

[reshmakala]

Hi guys!

I have a very simple incremental load script where I am trying to use NOT EXISTS. It gives me a "missing SELECT Keyword" error. Can anyone help me on this please?

My script:

IF NOT Alt(FileSize('Data.qvd'),0) >0 THEN

  TRACE 'file doesnt exists';

Data:

LOAD Country,

Loc_Key

....

;

SQL SELECT

Country,

Loc_Key,

....

FROM "XYZ"

WHERE Country='USA';

STORE Data into Data.qvd(qvd);

ELSE

trace 'file exists';

Data:

LOAD * FROM Data.qvd(qvd);

Concatenate (Data)

LOAD Country,

Loc_Key

....

;

SQL SELECT * FROM (SELECT

Country,

Loc_Key,

....

FROM "XYZ"

WHERE Country='USA')

WHERE NOT EXISTS(Loc_Key);

STORE Data into Data.qvd(qvd);

ENDIF;

[MK_QSL · Accepted solution]

Data:

LOAD * FROM Data.qvd(qvd);

Concatenate (Data)

LOAD

     Country,

     Loc_Key

     ....

WHERE NOT EXISTS(Loc_Key);

SQL SELECT * FROM

     (SELECT

          Country,

          Loc_Key,

          ....

          FROM "XYZ"

          WHERE Country='USA');

[reshmakala]

Thank you!