:REPLACE_STRUCTURE

Read or Modify Objects

:SET_CALE

---

:RESOLVE

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

Syntax

:RESOLVE String

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 Elements - Read or Modify Objects
Agent Variables

Sample Collection:
Database Maintenance with Options
About Scripts
Script Elements - Alphabetical Listing
Script Elements - Ordered by Function