Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Skip the ticket, Chat with Qlik Support instead for instant assistance.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Wait command in script

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!

1 Solution

Accepted Solutions
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand

View solution in original post

4 Replies
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand
Not applicable
Author

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
Partner - Contributor III
Partner - Contributor III

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

Not applicable
Author

Thanks!