Variables Overview

The following table provides an overview of the types of variables available in CA Automic Workload Automation and where they can be used.

Object, PromptSet and script variables are only available in executable objects (see Object Classes and Object Types).

Variable objects Description Usage
  • Dynamic Variable objects
    (source: EXEC, SQL, SQLI, MULTI and FILELIST)

Variable objects store values (static) or retrieve them from a particular data source (dynamic).

The values are stored and supplied in table form with a particular data type, format and value area.
Values are accessed either by a key or a result column and the columns are addressed via numbers (1 to n).

Values retrieved by variable objects can also be used in attribute fields of executable objects by using following syntax:
{VARA object name [, Key [, Column ] ] }

Script variables    

Data types:

  • string (default)
  • unsigned
  • signed
  • float

Syntax:
&
Variable name#

Script variables are specifically used for storing and using values in Process Pages .They can also be used in some attributes.

You can use the script element :DEFINEin order to declare script variables with a particular data type or to declare a variable's array.

To assign a value to a script variable, use the script elements :SET, :RSET or :PSET

Predefined script variables    
  • Predefined variables for system values,
  • Predefined variables for object values

(See List of Predefined Variables for System and Object Values)

Syntax:
&$
Variable name#

Predefined variables are placeholders that refer to the values of the system or the object in which they are used.
Their names and values are predefined and cannot be changed.

See Adding Predefined Variables to Objects and Scripts.

Object and PromptSet variables    
  • Object variables
  • PromptSet variables

See Object and PromptSet Variables.

Syntax:
&
Variable name#

You can create Object variables in an executable object by

PromptSet variables are derived from PromptSet objects (PromptSets (PRPT)), which can be assigned to an executable object. The default values defined in a PromptSet object can be overwritten in the executable object itself, as well as in the task properties of a Workflow.

Object and PromptSet variables can be used in various object locations. They can also be inherited by child objects.