Inside Automation Engine > XML Files of Objects > Variable > Dynamic Variable Types

Dynamic Variable Types

This document includes examples for the specific XML elements of the various sources for dynamic Variable objects. XML examples are also provided for the attributes which depend on the selected Variable's data type.

Source

EXEC

Example:

<EXEC>  
<ExecObject>EVNT.DB.NEW.6</ExecObject>  
<VaraResult>&variablename#</VaraResult>  
<Parameters>  
<row Lnr="1" VName="&hostname#" Value="anyhostname" id="35749486"/>  
<row Lnr="2" VName="&port#" Value="12345" id="35749486"/>  
<row Lnr="3" VName="&text#" Value="&reftext#" id="35749486"/>  
</Parameters>  
</EXEC>

SQL

Example:

- <SQL>  
<Conn>CONN.DB.SQL</Conn>  
<Login>LOGIN.DB</Login>  
<prefUserConn>0</prefUserConn>  
<prefUserLogin>0</prefUserLogin>  
<sql>select * from col</sql>  
<resultformat>{1}_{2}<resultformat/>  
</SQL>

SQL-Internal

Example:

- <SQL_INTERN>  
<command.sql>select * from eh</command.sql>  
<command.ora/>  
<command.db2/>  
<command.db2zos/>  
<resultformat>{1}_{2}<resultformat/>
</SQL_INTERN>

Multi

Example:

- <MULTI>  
<Vara1>VARA.1</Vara1>  
<Vara2>VARA.2</Vara2>  
<resultformat/>  
<union>1</union>  
<intersection>0</intersection>  
<minus>0</minus>  
</MULTI>

Filelist

Example:

- <FILELIST>  
<directory>C:\temp\*.txt</directory>  
<HostDst>WIN01</HostDst>  
<preferUserHost>0</preferUserHost>  
<Login>LOGIN.GLOBAL</Login>  
<preferUserLogin>0</preferUserLogin>  
</FILELIST>

Data Type

Text

<MinValue_C/>  
<MaxValue_C>12</MaxValue_C>
<uppercase>1</uppercase>

Number

<OutputFormat_N>00.00</OutputFormat_N>  
<MinValue_N>0</MinValue_N>  
<MaxValue_N>10</MaxValue_N>

Time

<OutputFormat_TI>hhmmss</OutputFormat_TI>  
<MinValue_TI>08:00</MinValue_TI>  
<MaxValue_TI>10:00</MaxValue_TI>

Time Stamp

<OutputFormat_TS>yyyymmddhhmmss</OutputFormat_TS>
<MinValue_TI>08:00 01.01.2010</MinValue_TI>
<MaxValue_TI>10:00 01.04.2010</MaxValue_TI>

Date

<OutputFormat_D>dd-mon-yyyy</OutputFormat_D> 
<MinValue_D>01.01.2010</MinValue_D> 
<MaxValue_D>01.04.2010</MaxValue_D>