Square Bracket Notation

Most component properties can contain SBN expressions that are evaluated before being used by the Sybase ETL Server on project configuration, simulation, or execution. An SBN expression is a JavaScript expression surrounded by square brackets [..]. Multiple SBN expressions can be used within a single string value.

You can use SBN expressions in component properties like:

Examples

A literal is a string surrounded by quotes. If you use SBN in a literal, the SBN is evaluated first.

‘Arrival Date: [uDate(‘now’, ‘localtime’)]’

This expression specifies the path of a file in the Text Data Provider:

 [uSystemFolder(‘APP DEMODATA’)]\PRODUCTS.TXT

NoteIn the Property window of components, the Eval column indicates whether a value entered is evaluated to resolve SBN expressions. For many property items, the Eval column is optional. To toggle the Eval check box, right-click the property item and select Evaluate.