How to use parameter file with sql override?

[jisoo23]

Is it possible to use variables from a parameter file in a sql statement within the sql qualifer? Whenever I try to validate, DB2 doesn't like the '$$' portion of the parameter variables. Has anyone done this before?

 

[blom0344]

Is it possible to fetch the parameter-value from OPB_MAP_PARMVAR in the override-statement?

Ties Blom
Information analyst

 

[jisoo23]

A-ha, I just figured it out! You can toss the parameter variables into the source filter in the session, not in the mapping! Apparently the variables' values get tossed in at the session level before going into the mapping and actually executing any SQL that it needs to do. In cases where the variables are strings, simply surround them with single quotes (it won't interpret them as a static $$variable name, the actual value will be substituted in).