2 Replies Latest reply: Mar 28, 2017 11:52 AM by Kuljit Chhabra RSS

    DB2 Incremental dataload script error

    Kuljit Chhabra

      Hello Qlik gurus,

       

      I am trying to configure DB2 incremental data load and having some trouble setting it up. I am using the following script. When I supply the time stamp the script works fine but when I use #$(LastExecTime)# then it gives me following error. Please help

       

      The following error occurred:

       

      Unable to get column information for the fields that are used in the query: ERROR [42S22] [Qlik][ODBC DB2 Wire Protocol driver][UDB DB2 for Windows, UNIX, and Linux]## NOT COLUMN OF INSERTED/UPDATED TABLE, OR ANY TABLE IN A FROM CLAUSE.

       

      Script:

      [VENDOR]:

      SELECT "VENDOR_ID",

        "NAME",

        "ADDRESS_1",

        "CONTACT",

        "CITY",

        "PROVINCE",

        "POSTAL_CODE",

        "BUSINESS_PHONE",

          "ROW_TIMESTAMP"

      FROM "TMWIN"."VENDOR"

      // WHERE row_timestamp < '2016-01-27 00:00:00.000000'

      WHERE ROW_TIMESTAMP > #$(LastExecTime)#;

       

      Best regards,