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