When setting up a project or job, you can customize:
SQL queries for setting up the source components
SQL commands for processing tasks
Expressions, conditions, and procedures to manipulate the transformation process
The format of SQL commands depends on the database system that is connected to the component. However, the format of the transformation language supported by Sybase ETL (JavaScript) does not change, regardless of the source or target system you use in your projects.
You can include JavaScript expressions in Square Bracket Notation (SBN), which considerably reduces your customization efforts. SBN expressions can be part of component properties (if the Evaluate option is activated for the specific property), like SQL statements, or any processing commands. An SBN expression is evaluated at runtime, as opposed to constant values, which are defined at design time. See “Evaluating SBN expressions”.
