User Guide > Scripting > EZscript Script Editor
Was this helpful?
EZscript Script Editor
EZscript Scripting Language
The EZscript is an Actian DataConnect scripting language that includes functions, operators, statements, variables, object variables, and error objects. EZscript is similar to Visual Basic (VB), but there are a few key differences such as:
EZscript supports both functions and subroutines (a user-defined function may or may not return a value). The scripting language does not distinguish between them in the definition.
EZscript is supported in both Windows and Linux platforms.
EZscript does not include all VB script functions. However, EZscript includes custom functions that are nonexistent in VB such as the file management functions FileRead and FileRename.
EZScript Editor
The EZScript Editor is the interface for creating and managing EZscript expressions. You can use the EZScript Editor to:
Create or modify EZscript Library artifacts in Project Explorer and then use them in a map.
Define filters for source and target fields
Define sort options for source data
Add an expression for the applicable target fields in the map.
Specify a value for the applicable parameters using EZscript when adding events to a map
Add EZscript step or add expressions in Start or Stop step in process to specify input/output file, define properties of message components, or mange logical variables.
Accessing EZscript Editor
You can access the EZscript Editor from multiple locations that are listed in the following table:
Location
Details
Project Explorer
Create or open an EZscript Library artifact. The EZscript Library file opens in a separate tab.
For information to create or open an existing EZscript artifact, see Managing Workspaces, Projects, and Integration Artifacts
Map file > Sources tab
In the Define Filters section, click . The EZscript Expressions window is displayed.
In the Define Sort Options section, click to add a field. The field is added to the fields list. Click the field that is added and from the drop-down list, select <Build Expression..>. The EZscript Expressions window is displayed.
From the Source drop-down menu, select Constants. In Value Expression field, click ... The EZscript Expressions window is displayed.
Map file > Targets tab
In the Define Filters section, click . The EZscript Expressions window is displayed.
Map file > Mapping tab
In the Expression column, click the required field and then click .... The EZscript Expressions window is displayed.
Map file > Configuration tab
In Map Events section, click . Select the events, actions, and parameters.
You can specify a value for a few parameters using EZscript. To do this, in the Value column, click .... The EZscript Expressions window is displayed.
Process file > Step Builder Canvas tab
From the Palette, drag and drop a Script step. The properties tab for the script step is displayed at the bottom. Double-click the Script step or select the Expression option and click Open. The EZscript Expressions window is displayed.
Process file > Step Builder Canvas tab > Start step
Double-click the Start step or in the Start tab, select the Expression option, and click Open. The EZscript Expression window is displayed.
Process file > Step Builder Canvas tab > Stop step
Double-click the Stop step or in the Stop tab, select the Expression option and click Open. The EZscript Expressions window is displayed.
Last modified date: 12/03/2024