FILELIST VARA objects obtain the file names of a particular directory as its values. Specifying an Agent is mandatory. On Windows agents, the file names are sorted in ascending order. On UNIX agents, the file names are unsorted.
Important! FILELIST VARA objects contain only one column (as opposed to SQL, SQL-internal and Multi). Keep this in mind when using the script element GET_PROCESS_LINE. There is no result column.
PromptSet variables are supported in select fields for BACKEND, EXEC, FILELIST, SEC_SQLI, SEC_SQL, SQLI, SQL, and XML variable types. Using PromptSet variables is necessary when using the Dynamic Reload (Combobox Prompts) feature.
Defining FILELIST VARA Objects
A FILELIST VARA object definition is made up of the following pages:
Common to all object types, here you define basic object information and apply custom values to it
Here you define the object-specific settings. Some sections on this page are common to all VARA objects and are described for all of them in dedicated topics. This topic describes the FILELIST-specific settings on the Variables page.
Common to all object types, here you find a list of all versions of the object
Common to all object types, here you enter information that you consider important to understand the configuration and behavior of the object
To Define a FILELIST VARA Object
In the Variable Settings section specify how the VARA object is going to access the target system from which it retrieves the values.
Read-only, always Filelist for this type of VARA objects.
The OS Agent that is used to access the directory. Agent Groups are not allowed.
If you do not select anything, the Agent of the task that uses the VARA object is applied.
- A runtime error occurs if the VARA object is used in an object to which no Agent or Login has been assigned.
- File Transfer object as source: If you do not assign an Agent, the Agent that is defined in the destination settings of the File Transfer object is used.
You can include PromptSet variables here when using the Dynamic Reload (Combobox Prompts) feature for combo box prompts. When you use PromptSet variables in a dynamic VARA object, the Preview feature returns an error. This is because the PromptSet variables do not exist in the dynamic VARA object. However, the PromptSet variables will be resolved when objects including the PromptSet are executed.
Apply Task Agent
Deploys the Agent of the task that uses the VARA object. If the task does not have an Agent (such as, for example, in Script objects), the Agent of the VARA object is used. If neither the VARA object nor the task has an Agent, an error occurs.
Login (LOGIN) object that allows the VARA object to access the Agent.
Apply Task Login
Deploys the login of the task that uses the VARA object.
If the task does not have a Login object assigned, (such as, or example, in Script objects), the Login assigned to the VARA object is used. If neither the VARA object nor the task has a Login object, an error occurs.
The directory from which the file names should be returned as a value list when the VARA object is accessed. For example, on a Windows computer it could be:
You can also limit the list to files with a particular name or suffix. To set such filters, use "*" (several characters) or "?" (exactly one character). For example:
- Define the Data Types and Formatting.
- Define the Script Access.
- If you are logged in to Client 0, an additional section is available. For more information, see Client 0 VARA Objects in Other Clients.
- Click the Preview button to validate the VARA object. This function checks whether the directory exists, if the Agent is available, if there is read access to the path, and so on. If the settings are correct, the file list is displayed.
- Save your changes.