Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
using Qlik SAP SQL Connector we're performing standard SQL select to read tables like:
SELECT *
From Table;
Is it possible to update the content of a Z table (custom table, not a standard SAP table) using somenthing like:
SQL UPDATE ZTABLE
SET FLAG= '1'
WHERE CONDITIONS ......;
Using UPDATE statement i'm getting below error:
Hi,
The Qlik SAP SQL connector can only be used to fetch data. Update statements are not allowed.
Regards,
Håkan
Hi,
The Qlik SAP SQL connector can only be used to fetch data. Update statements are not allowed.
Regards,
Håkan
@micheledenardi ,
As @Hakan_Ronningberg explained, Qlik SAP SQL connector acts as an "Analytics" tool, loading data from SAP to Qlik Sense for analysis. This connector does not support "writing back process". Thus, UPDATE statement is not supported
Regards