Wait command in script

[#1]

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!

[Gysbert_Wassenaar · Accepted solution]

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

[#3]

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"?

[arbernardez]

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

[#5]

Thanks!