Hi,
I am passing a hard coded filter condition to the job parameter and there by using it as a constraint in the transformer stage. but it is giving an error saying missing =..
the actual condition is
linkname.columnname=2 AND (linkname.columnname=\'A\'OR linkname.columnname=\'M\')
even the simple linkname.columnname=2 is also not working throwing the same error.
Any help!
Thanks,
passing a hard coded filter condition for a job parameter
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
The Transformer stage will never accept a column name from a job parameter. You can only pass in Values and Constants, not column names. The easiest way to pass in an entire constraint including the column name is to use the Filter Stage. Some of the specialised parallel stages such as Filter and Modify can use run time column names. With the filter stage your entire Where Clause can be a job parameter.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn