Script Function: It resolves any kind of variable (Prompt values, System variables, Script variables, Variable objects) in text.
RESOLVE_VAR(Variable)
| Syntax | Description/Format | 
|---|---|
| Variable | The name of a Variable object, whose value should be resolved. Format: script literal or script variable | 
The first line in the following example sets the &txt Script variable to the string "This is version ", followed by the value of the SQLI Variable object VARA.SQLI_TEST, which includes SQL that returns the version and build numbers. The second line prints it out.
:s &txt# =  RESOLVE_VAR("This is version {VARA.SQLI_TEST}")
:p  &txt#
The report output for this example would look something like the following:
2014-11-18 11:50:22 - U00020408 This is version 11.0.0+build.2751
The following example sets the &var Script variable to the string "{VARA_RESOLVE,key1,1}", which is the name of a static Variable object. Then it prints the &var Script variable. Next, it resolves the Script variable based on a key 1, value 1 of VARA_RESOLVE and prints it out.
:s &var# = {VARA_RESOLVE,key1,1}
:p  &var#
:s &val# = RESOLVE_VAR(&var#)
:p &val#
The report output for this example would look something like the following:
2014-11-18 17:50:32 - U00020408 {VARA_RESOLVE,key1,1}
2014-11-18 17:50:32 - U00020408 this is the main key
See also:
| Script element | Description | 
|---|---|
| Deletes one or all values of a static Variable object. | |
| :PUT_VAR | Stores a value in a static Variable object. | 
| :SET_SCRIPT_VAR | Sets the values of Script variables by indirect access. | 
| GET_SCRIPT_VAR | Returns the values of Script variables by indirect access. | 
| GET_VAR | Returns the value of a Variable object. | 
| PREP_PROCESS_VAR and PREP_PROCESS_VAR_XML | Prepares the processing of a data sequence (values of a Variable object). | 
Script Elements - Read or Modify Objects
Sample Collection:
Database Maintenance with Options
Calling an MBean
        
About Scripts
Script Elements - Alphabetical Listing
Script Elements - Ordered by Function