3 Replies Latest reply: Jan 7, 2011 8:51 AM by Dominic Ayling RSS

    Incremental load where criteria on QVD not working?

    Dominic Ayling

      Hi All

      I'm trying to do an incremental load that is based on a date field but when I come to load in the QVD and concatenate to the incremental load my where condition wont work, it just gives me the same 4 records as incremental load? I've tried reversing the greater than symbol (though that doesn't seem to make sense) but this just loads everything. Here's the code:

      [CODE]concatenate(List) LOAD "AC_ACCOUNT",
      "CS_COST_CENTRE",
      "GL_TRANSACTION_TYPE",
      "GL_BATCH_REF",
      "GL_DESC",
      "GL_AMT",
      "PD_PERIOD",
      "GL_ANALYSIS_1_ID",
      "GL_VOL",
      "GL_REF",
      "SLT_OUR_REF_2",
      "SLT_THEIR_REF",
      "NA_CODE",
      "NA_NAME",
      "PD_YEAR",
      "GL_SUB_LEDGER",
      "GL_POSTING_SYSDATE"
      FROM
      List.qvd
      (qvd)
      where (not GL_POSTING_SYSDATE>$(MAXGL_POSTING_SYSDATE_2));[/CODE]

      Please can anyone advise what I'm doing wrong?

      Thanks

      Dominic