RESOLVE_VAR

Script Function: It resolves any kind of variable (Prompt values, System variables, Script variables, Variable objects) in text.

Syntax

RESOLVE_VAR (Variable)

Syntax

Description/Format

Variable

The name of a Variable object, whose value should be resolved.

Format: script literal or script variable

Examples

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}")

: &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}
: &var#

:s &val# = RESOLVE_VAR(&var#)
:&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

:DELETE_VAR

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

Agent Variables

Sample Collection:
Database Maintenance with Options

Calling an MBean

About Scripts
Script Elements - Alphabetical Listing

Script Elements - Ordered by Function