Storing the data into a macro variable ($HMLSQLUtil$)

The default destination for the data resulting from an SQLQuery action is the Host On-Demand macro variable $HMLSQLUtil$. The Host On-Demand runtime always updates this variable with the results of a successful SQLQuery action.

To store data into $HMLSQLUtil$, expand the Output Result To list box 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$.