When setting up a project or job, you can customize:
SQL queries for setting up the source components
SQL commands for preprocessing and postprocessing 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 Notations (SBN) expressions, which considerably reduces your customization efforts. SBN expressions can be part of component properties (if the Evaluate option is activated for the specific property), SQL statements, or any preprocessing or postprocessing commands. An SBN expression resides inside an opening and a closing square bracket and is evaluated at runtime, as opposed to constant expressions, which are defined at design time.
