I am trying to write a function for my loaders. What I am trying to do is that I take a date from a log file and once that date from the log file is the same as the current date then to run the rest of the script but if it doesn’t meet the current date it will keep checking the log until the date equals the current date.
So something like this:
Function runLoader() If date = Today then run the rest of the script Else keep checking the date
I think I understand. This problem is typically solved by triggering the reload externally from the job that creates the file. However, it could be done in script as you've asked like this:
DO until NoOfRows('logtable') > 0
Trace Reading log file;
logtable:
LOAD Date,
Message
FROM
logfile.txt
(txt, codepage is 1252, embedded labels, delimiter is ',', msq)
The log file contains a date once the job that generates the log has been completed.
I have created a loader to create QVD's but what I want to do is write a function so that it checks this log file and when the date in the log file is the same as the current date, the function stop and the rest of the script will run.
I think I understand. This problem is typically solved by triggering the reload externally from the job that creates the file. However, it could be done in script as you've asked like this:
DO until NoOfRows('logtable') > 0
Trace Reading log file;
logtable:
LOAD Date,
Message
FROM
logfile.txt
(txt, codepage is 1252, embedded labels, delimiter is ',', msq)
