Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Can QlikView commit in a loadscript?

Hi,

I will be calling a procedure in a loadscript that will be committing to a database table.

Do I need a commit in my PL/SQL procedure or can QlikView do the commit? Does QlikView automatically commit?

I've had a search around but can't see anything about this.

Thanks,

Jamie

1 Solution

Accepted Solutions
Highlighted
Champion III
Champion III

AFAIK we do not have any native COMMIT keyword that Qlikview can do. However, QV respects all the native SQL features. So what every SQL script you give after SQL Select keyword or Exec a SP you can use COMMIT in your SQL Script which Qv runs. This is what i believe.

View solution in original post

3 Replies
Highlighted
Partner
Partner

Not sure about this. but i think its a fair assumption that you need to commit on the stored procedure. Because writing into a DB is not the intended feature of Qlik i dont believe they would have commits anywhere

Highlighted
Creator III
Creator III

Logically it seems possible - As

'SQL Select'  keywords in Qlik Script are nothing but the SQl Area invoked in Qlik. Worth checking it though. 

Highlighted
Champion III
Champion III

AFAIK we do not have any native COMMIT keyword that Qlikview can do. However, QV respects all the native SQL features. So what every SQL script you give after SQL Select keyword or Exec a SP you can use COMMIT in your SQL Script which Qv runs. This is what i believe.

View solution in original post