Once you have created the parameterized expressions, you can either embed them in a
fragment like a function call, or nest it in another parameterized expression.
Using parameterized expressions in a fragment
You can call a parameterized expression in a fragment by starting to type its name, and
then the auto-completion displays the defined parameterized expression. You can also
directly drag and drop the parameterized expression in the fragment editor or use the
Copy and Paste options. In this example, the
genAddress parameterized expression is called in a fragment:
When you use a parameterized expression in a fragment, the expression editor is split in
two parts:
On the left, the expression you have entered.
On the right, the generated expression where the placeholders have been replaced by
the actual content, which is called the virtual expression. This part is not
editable.
Using parameterized expressions in another parameterized expression
You can call a parameterized expression inside another parameterized expression. In this
example, the genAddress parameterized expression is called in the
genCustomer parameterized expression:
Viewing parameterized expressions in the DSQL Script
view
Once you have added the parameterized expression in your mapping, you can view the defined
parameterized expression in the DSQL Script view by clicking
Generate parameterized expression(s):
Did this page help you?
If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!