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,
