I'm writing a script set_time.sql
the sets a time variable by hosting to dos.
The variable displays the current time the first time the script is called from SQL>@set_time
but when I executed the script again,
the variable stays the same.
My question is how to refresh (clear) the variable
so each time the script is called it displays the new time?
host Set HHMISS=%TIME%
host echo %hhmiss%