I have to implement the bellow scenario in QlikView Script. Can anyone assist on this?
Scenario: I have connected to the SQL Server using OLDB connection String. I have to load 7 tables from the database. After reading the data from 3 tables the connection may lost due to unidentified reasons. Then Instead of abending the execution, the compiler has to wait for some time(2 mins) by trying to establish connection again and again with the database. If the re-connection is done with in the time(Ex: 2 Mins) the execution have to go in smooth manner otherwise the execution should fail.