Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
vishsaggi
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
dplr-rn
Partner - Master III
Partner - Master III

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

jayanttibhe
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. 

vishsaggi
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.