Square Bracket Notation

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

You can use SBN expressions in component properties like:

SQL queries
Processing SQL statements
Transformation rules
File names
Path definitions
URLs

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

Note:

In 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.