The trace statement writes a string to the Script Execution Progress window and to the script log file, when used. It is very useful for debugging purposes. Using $-expansions of variables that are calculated prior to the trace statement, you can customize the message.
The following statement can be used right after the Load statement that loads the 'Main' table.
Trace Main table loaded;
This will display the text ‘Main table loaded’ in the script execution dialog and in the log file.
The following statements can be used right after the Load statement that loads the 'Main' table.
Let MyMessage = NoOfRows('Main') & ' rows in Main table';
This will display a text showing the number of rows in the script execution dialog and in the log file, for example, ‘265,391 rows in Main table’ .