Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
jamietomkins
Partner - Contributor II
Partner - Contributor II

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.