Script statement: Stores a value to a particular column of a static Variable objectAutomation Engine controlled activities and processes are structured in the form of objects. See also: Task.
:PUT_VAR_COL Variable, [Key], Column, Value
Syntax |
Description/Format |
---|---|
Variable |
Name of the Variable object to which a value should be assigned. |
Key |
Line in which the value should be stored. |
Column |
Number of the column in which the value should be entered. Allowed values:
|
Value |
Value which should be written to the specified variableIt stores or retrieves values dynamically at runtime. An individual Automation Engine object type. line and column.
|
This scriptA particular Automation Engine object type. functionPre-defined run book template in the Automation Engine. One single step only, e.g. Start Windows Service, Copy file,… writes a particular value to the specified line and column of a Variable object. Unlike with the script element :PUT_VAR, this does not affect other fields. If the specified line/column already contains an entry, the corresponding value will be overwritten.
Specifying a dynamic variable in this script element (source: SQL, SQL-internal, multi or data type) results in a runtimeThe duration of a task's execution. It refers to the period between a task's start and end. It does not include its activation period (see also: activation and start). error. Only static Variable objects can be filled with values using :PUT_VAR_COL.
When indicating the column number, keep in mind that Variable objects of type "static" only include 5 value columns.
For use with the static Variable object XML, the number of value columns is "1" only.
The use of XPath expressions with the Variable object XML is possible, but depending on the databaseA database is an organized collection of data including relevant data structures. the Automation EngineThis component drives an Automation Engine system and consists of different types of server processes. system is being used with, individual XPath expressions may work differently. In such cases please check with the database's vendor.
The numbers between "1" (value column 1) and "5" (value column 5) can be used for the columns. The value of the Key columnColumn in static Variable objects that can be used to access values of a particular line. cannot be changed with this script element.
The parameter Key is only optional if a static variable is used with the setting "Scope" - "No validity keyword". In this case, the variable only includes the key (*).
A new entry is created if the specified Key does not yet exist.
The following example retrieves the name of the superordinate taskThere are various ways of activating objects. The originator of the activation is referred to as the superordinate task (parent). (workflowAn object of the Automation Engine that can include several executable objects and which runs them in a specified order. [Formerly called "ProcessFlow" and "JobPlan."]) and the taskAn executable object that is running. Tasks are also referred to as activities.'s own RunIDShort for "run number". It is a number that provides unique information about a task's execution. The RunID can include 7 to 10 digits. It is assigned by the Automation Engine component .. Subsequently, the RunID is written below the workflow name in column 3 of the Variable object "VARA.JOBP".
:SET &JOBP# = SYS_ACT_PARENT_NAME()
:SET &RUNID# = SYS _ACT_ME_NR()
:PUT_VAR_COL VARA.JOBP, &JOBP#, "3", &RUNID#
Using this script statement together with the Variable object XML, would look like this:
:PUT_VAR_COL VARA.XML.TEST2, "KEY3", "test/value1", "tetststs"
See also:
Script Element | Description |
---|---|
:PUT_VAR | Stores values in a static Variable object. |
:DELETE_VAR | Deletes one or all values of a static Variable object. |
GET_VAR | Returns the content entry of a Variable object. |
|
|
:SET_SCRIPT_VAR | Sets the values of script variables through indirect access. |
GET_SCRIPT_VAR | Returns the values of script variables through indirect access. |
PREP_PROCESS_VAR and PREP_PROCESS_VAR_XML | Prepares the processing of a data sequenceAn internal listing of Console outputs or lines of Variable objects, etc. The lines of a data sequence can be accessed by using a PROCESS loop or the script element GET_PROCESS_LINE. The script elements PREP_PROCESS* generate data sequences. (values of a Variable object). |
Script Elements - Read or Modify Objects
Sample Collection:
Display with Cockpit
Database Maintenance with Options
Calling an MBean
About Scripts
Script Elements - Alphabetical Listing
Script Elements - Ordered by Function
Automic Documentation - Tutorials - Automic Blog - Resources - Training & Services - Automic YouTube Channel - Download Center - Support |
Copyright © 2016 Automic Software GmbH |