Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

DB2 Incremental dataload script error

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,

Labels (1)
2 Replies
Not applicable
Author

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

Environment is Qlik Sense 2.2.3.0

Not applicable
Author