Developer Mapping Guide

10.2.2
- 10.5.7
- 10.5.6
- 10.5.4
- 10.5
- 10.4.1
- 10.4.0
- 10.2.1

Back Next

Tips for Using Parameters in SQL Statements

You can use tips to use parameters in SQL statements more effectively.

For a string parameter, use single quotes when you define the parameter in the query.

Do not use single quotes for a parameter if the parameter is not a string. You might get unexpected results.

For a string parameter, if the SQL query and the default value of the parameter do not have single quotes, you can add an upstream Filter transformation in the mapping. In the Filter transformation, edit the filter condition to include single quotes around the parameter.

A parameter name cannot contain a period (.) . An SQL query is not valid if it has a parameter that contains a period. For example, the following SQL statement has a parameter name that contains a period:

SELECT $tname.ID,"MY_SOURCE"."NAME" FROM "MY_SOURCE" where FIELDX=1

When you validate the query, the Data Integration Service returns an error that it cannot find the tname.ID parameter.

Rename Saved Search

Table of Contents

Developer Mapping Guide

Developer Mapping Guide

Tips for Using Parameters in SQL Statements

Tips for Using Parameters in SQL Statements