:RESOLVE

Script Statement: Tries to resolve all variables (Prompt values, System variables, Script variables, Variable objects) contained in the string.

Syntax

:RESOLVE String

Syntax	Description/Format
String	Script string. May contain any number of variables (Prompt values, System variables, Script variables, Variable objects) which shall be resolved. Format: script literal

Comments

This Script statement works like a combination of :SET and RESOLVE_VAR. Any variable contained in the string will be resolved.

A variable that can not be resolved will remain unchanged. The resulting value will be assigned to the variable.

Examples

This example sets the Script variable &ret# 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.

:RESOLVE &ret# = "This is version {VARA.SQLI_TEST}"
:PRINT &ret#

The report output for this example would look something like this:

2014-11-18 11:50:22 - U00020408 This is version 11.0.0+build.2751

The following example sets the Script variable &var# to the string "{VARA_RESOLVE,key1,1}" and it resolves this Script variable based on a key 1, value 1 of VARA_RESOLVE, which is the name of a static Variable object. Then it prints the &var# Script variable.

:RESOLVE &var# = "{VARA_RESOLVE,key1,1}"
:PRINT &var#

The report output for this example would look something like this:

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.
RESOLVE_VAR	Resolves any kind of variable (Prompt values, System variables, Script variables, Variable objects) in text.
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
About Scripts
Script Elements - Alphabetical Listing
Script Elements - Ordered by Function