Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

(1 Rating)
facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

HOW TO: Determine when to use quotes strings inside an Expression transformation and Lookup SQL override
Answer

In Expression Transformation, you should not use quote for mapping parameters/ variables and use quote for strings because mapping parameters/variables needs to be expanded by Integration service.

Example

REPLACESTR (0, SNAME, 'tel3', $$TARGET_SYSTEM||'tel3')

In above example, the mapping parameter and variable like $$TARGET_SYSTEM should not be within quotes and string like tel3 should be within quotes.

In a Lookup transformation, you should quote strings, Mapping parameters/Variables and not the Database reserved words. The Lookup override is sent to database and database server does no understand mapping parameters/variables (since they are PowerCenter reserved words.)

Example

SELECT price1, price2 FROM WHERE Date BETWEEN '$$BeginBillDate' AND '$$EndBillDate'

In the above example, you should not quote Database reserved words like BETWEEN, WHERE and quote mapping variables like $$BeginBillDate.


More Information

Applies To
Product: PowerCenter
Problem Type:
User Type: Administrator
Project Phase:
Product Version: PowerCenter 7.1.x; PowerCenter 8.1.x; PowerCenter 8.5; PowerCenter 8.5.1; PowerCenter 8.6; PowerCenter 8.6.1
Database:
Operating System:
Other Software:

Reference

Attachments

Last Modified Date:8/28/2009 11:56 AMID:23079
People who viewed this also viewed

Feedback

Did this KB document help you?



What can we do to improve this information (2000 or fewer characters)