topic Re: Test ODBC connection before load start in QlikView

Test ODBC connection before load start

louwriet — Mon, 28 Dec 2015 09:25:28 GMT

Hi,

I have a senario where i load data once a day from several databases via ODBC connections.(connectionstrings).

My problem is that this is a automated load process and sometimes when i have a problem with one connection the load stop to display connection error. What i would like is that if a ODBC connection is not successfull the load must carry on with the next connection of the following databases and skip the database that has a connection problem.

I was thinking in the line of :

IF connection1 success // HOW CAN I TEST CONNECTION WITHOUT HALTING ALL THE LOADS.

THEN

LOAD database1

END

IF connection2 success

THEN

LOAD database2

END

Help would be appreciated.

Regards

Louw

Re: Test ODBC connection before load start

MayilVahanan — Mon, 28 Dec 2015 10:56:03 GMT

Please refer

ErrorHandling in Qlikview

Re: Test ODBC connection before load start

Anonymous — Mon, 28 Dec 2015 11:00:20 GMT

check this:

Error Handling in Qlikview

Error handling in script

ErrorHandling in Qlikview

Error Handling in Qlikview | Business Intelligence

Re: Test ODBC connection before load start

Kushal_Chawda — Mon, 28 Dec 2015 11:15:34 GMT

connection1;

let vError = ScriptErrorCount;

if $(vError )>0 then

connection2;

Trace "Connection2 Successful";

else

Trace "Connection1 Successful";

End if

let vError =null();

Re: Test ODBC connection before load start

louwriet — Tue, 29 Dec 2015 12:03:52 GMT

Thank you Mayil , Balraj and Kush. All these post helped me.

best regards

Louw