Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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
Logically it seems possible - As
'SQL Select' keywords in Qlik Script are nothing but the SQl Area invoked in Qlik. Worth checking it though.
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.