Host variables in SQL

Previous Next

In USoft SQL, you can refer to substitution variables referred to as host variables that have previously been set using the USoft action language. USoft treats host variables in the same way that it treats resource settings read from the "usdi" and "usdiw" resource files in the \APP subdirectory of the USoft installation directory.

Functionally, the value of a host variable has global scope and remains referenceable from the time when it is set until the time when the same variable is set to a different value, or when the USoft session ends.

This help topic only shows how you set and get values of host variables generally, for example, in SQL Command. In the USoft toolset, there are multiple, tool-specific contexts where you can set and get host variables, for example, in Web Designer, in Windows Designer, and in Service Definer.

You can pass input values as decision variables to decisions, and then refer to them by position using :1, :2 ...

 

collapseSetting a host variable for use in SQL

 

collapseGetting a host variable in SQL

 

See also

SQL expressions