topic Re: Does Qlik SAP SQL Connector support UPDATE Statement? in Connectivity & Data Prep

Does Qlik SAP SQL Connector support UPDATE Statement?

micheledenardi — Fri, 05 Nov 2021 09:28:04 GMT

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:

Connector reply error: RfcAbapException:SQL_ERROR Forbidden words used

Re: Does Qlik SAP SQL Connector support UPDATE Statement?

Hakan_Ronningberg — Fri, 05 Nov 2021 09:49:40 GMT

Hi,

The Qlik SAP SQL connector can only be used to fetch data. Update statements are not allowed.

Regards,
Håkan

Re: Does Qlik SAP SQL Connector support UPDATE Statement?

Joseph_Musekura — Fri, 05 Nov 2021 14:37:16 GMT

@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