Skip to main content Skip to complementary content

Creating parameterized expressions

You can create parameterized expressions by clicking DSQL Parameterized Expressions DSQL Parameterized Expressions on the top bar.

DSQL Parameterized Expressions view

DSQL Parameterized Expressions view.
Properties Description
New parameterized expression Click New parameterized expression to create a new parameterized expression, and enter a name.

The name of the new parameterized expression must be a valid DSQL identifier, and must be unique.

Delete parameterized expression(s) Click Delete parameterized expression(s) to delete one or more selected parameterized expressions.
Sort parameterized expressions Click Sort parameterized expressions to sort the created parameterized expressions alphabetically in the list.
type filter text Enter any text to filter the created parameterized expressions.
Name Enter a name for the parameterized expression.

The name is case insensitive and must be unique.

Description Enter a description for the parameterized expression.
Parameters Enter one or more parameters, separated by a comma.

If the parameterized expression has no parameter, let the field empty.

Information noteTip: If you want to rename a parameter that is already used in the expression, you can right-click and select Rename parameter. All the references to the old name are then updated with the new name in the expression.
Expression Enter the expression to be used in the parameterized expression. The expression can contains:
  • a Data Shaping Expression Language expression
    concatWith(delimiter, address.street, address.city)
  • a block
    {
                street = address.street,
                city = address.city,
                zipcode = address.zipcode
    }
  • a query or a sub-query
    (
                FROM cust
                SELECT {
                  custid = custid,
                  name = name,
                  address = genAddress(address),
                  rating = rating
      }
    ) 
  • a comment
  • a recursive expression
Information noteTip: You can drag and drop a function or an input map element in the content of the parameterized expression.
Information noteTip: You can change the view of the DSQL Parameterized Expressions view from vertical to horizontal by clicking Switch Layout Switch Layout.

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!