topic Re: Wait command in script in QlikView

Wait command in script

Thu, 19 Dec 2013 13:18:01 GMT

Hi all,

I am writing a script that runs a set of SQL commands and then joins data to an external source in order to create a report. Works perfectly. Unfortunately one of my SQLs is a DBMS output, which I am quite sure qlikview doesn't support. So I need to run this DBMS SQL (at least for now) externally and save as a .csv.

The SQL queries in the beginning of the script take about 30 minutes to run. I don't want to get through all of these and not have my DBMS output for the day completed. I know I can run that first, then the script, but that is not most time efficient.

Long story short - Is there some sort of wait command in the script? My pseudo code would be:

do While date(DBMS.filedate) < today

wait 60 seconds

loop

Is there another way to accomplish "stalling" the script? Hope this makes sense. Thanks!

Re: Wait command in script

Gysbert_Wassenaar — Thu, 19 Dec 2013 13:23:48 GMT

You can use Sleep to halt execution for x milliseconds: sleep 60000

Re: Wait command in script

Thu, 19 Dec 2013 13:36:12 GMT

Thank you! One more - do you know if there is a way to show text in the execution window such as

'In wait Loop - Iteration ' & vcounter

which would show "In wait Loop - Iteration 5"?

Re: Wait command in script

arbernardez_old — Thu, 19 Dec 2013 13:40:45 GMT

the function TRACE allows you to show info meanwhile the script is being loaded

it works out of LOAD Statement

example:

TRACE some text here;

Regards!

Alberto Rodríguez Bernárdez

Re: Wait command in script

Thu, 19 Dec 2013 14:21:46 GMT

Thanks!