Example

The following example of a SQL query shows how to include a parameter. The example queries the employeeList data service for records, and when the data service transformation is executed, any use of the parameter employeeRegion in it will be substituted with the value USA EAST. This parameter can be in any transformation step that allows variable or parameter substitution.

You can also assign a value to the parameter in the Connection Properties window.

Using the following sample syntax:

SELECT * FROM '<*data service name*>' WHERE PARAMETER('<*parameter\_name*>') = '<*parameter\_value*>'

The following query would be used for our example:

view sourceprint
   SELECT * FROM '*employeeList*' WHERE PARAMETER('*employeeRegion*')='*USA EAST*'