Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
louwriet
Contributor

Test ODBC connection before load start

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

Tags (3)
1 Solution

Accepted Solutions
balrajahlawat
Esteemed Contributor

Re: Test ODBC connection before load start

4 Replies

Re: Test ODBC connection before load start

Hi

Please refer

ErrorHandling in Qlikview

balrajahlawat
Esteemed Contributor

Re: Test ODBC connection before load start

Re: Test ODBC connection before load start

connection1;

let vError = ScriptErrorCount;

if $(vError )>0 then

connection2;

Trace "Connection2 Successful";


else

Trace "Connection1 Successful";

End if


let vError =null();


louwriet
Contributor

Re: Test ODBC connection before load start

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

best regards

Louw

Community Browser