Storing the data into a global variable ($HMLSQLUtil$)
The default destination for the data resulting from an SQLQuery
action is the global variable $HMLSQLUtil$. The Host On-Demand runtime
always updates this variable with the results of a successful SQLQuery
action, even when you specify a destination of File or Display in
the Output Result To listbox. For example, when you specify a destination
of File, then Host On-Demand:
- Writes the data resulting from the SQLQuery action into the file you specify; and also,
- Writes the data into $HMLSQLUtil$.
To store data only into $HMLSQLUtil$, expand the Output Result To listbox and click $HMLSQLUtil$.
To use the data stored in $HMLSQLUtil$ in a subsequent macro action, you must invoke methods from the Host On-Demand Macro Utility library (HML library) associated with $HMLSQLUtil$. See $HMLSQLUtil$.