Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
micheledenardi
Specialist II
Specialist II

Does Qlik SAP SQL Connector support UPDATE Statement?

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
 
 
Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.
1 Solution

Accepted Solutions
Hakan_Ronningberg

Hi,

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

Regards,
Håkan

View solution in original post

2 Replies
Hakan_Ronningberg

Hi,

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

Regards,
Håkan

Joseph_Musekura
Support
Support

@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