DB2 Incremental dataload script error

Tue, 28 Mar 2017 15:49:33 GMT

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,

Re: DB2 Incremental dataload script error

Tue, 28 Mar 2017 15:52:06 GMT

I have been following the following link on Qlik support - Case 3.

Environment is Qlik Sense 2.2.3.0

Re: DB2 Incremental dataload script error

Tue, 28 Mar 2017 15:52:50 GMT

Using QVD files for incremental load ‒ QlikView

topic Re: DB2 Incremental dataload script error in QlikView

DB2 Incremental dataload script error

Re: DB2 Incremental dataload script error

Re: DB2 Incremental dataload script error