How to manage connections in load script?

Tue, 19 Mar 2013 20:22:47 GMT

Hi, all

i was trying to use reloads depending on some condition from different databases (below is a part of my code) and met with such problem: connections do not depend on condition, i.e. connections are made always, the script make connections and then load or not load in dependence on condition... i would like my script not to connect to database if i will not to reload from it... How to solve the problem?

if ($(vFlagForReload) = 1)then

OLEDB CONNECT32 TO (XPassword is AHfQWEGBT);

// load from some tables from DB1

end if;

if ($(vFlagForReload) = 2)then

OLEDB CONNECT32 TO (XPassword is AHQWERTYU);

//partial reload from some tables of DB2

end if;

Re: How to manage connections in load script?

kaushiknsolanki — Wed, 20 Mar 2013 07:10:05 GMT

Hi,

This code should work. Only remove the ';' after End if

What is the error which you are getting.

Regards,

Kaushik Solanki

topic How to manage connections in load script? in QlikView

How to manage connections in load script?

Re: How to manage connections in load script?