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.

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 tabs. They can also be used in some attributes.

You can use the script element :DEFINE in 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    

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.
Object and PromptSet variables    

Syntax:
&
Variable name#

You can create Object variables in an executable object by

PromptSet variables are derived from PromptSet objects, 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.