Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

How to manage connections in load script?

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;

1 Reply

Re: How to manage connections in load script?

Hi,

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

     What is the error which you are getting.

Regards,

Kaushik Solanki

Community Browser