topic Re: Can QlikView commit in a loadscript? in QlikView

Can QlikView commit in a loadscript?

Anonymous — Wed, 10 Oct 2018 09:31:18 GMT

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

Re: Can QlikView commit in a loadscript?

dplr-rn — Wed, 10 Oct 2018 16:19:29 GMT

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

Re: Can QlikView commit in a loadscript?

jayanttibhe — Wed, 10 Oct 2018 16:49:27 GMT

Logically it seems possible - As

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

Re: Can QlikView commit in a loadscript?

vishsaggi — Wed, 10 Oct 2018 16:57:48 GMT

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.