IBM Information Server - How to pass parms in a select SQL

[Chandrathdsx]

Hello,

I am trying to pass a where clause value to a relational/odbc/teradata connector stage.
Exampe: I want to extract data from Address table by passing the state-code and write it to a dataset. I want to pass the state-cd as a job parameter and override every time with a state value (like, MN, IL, NY etc) and run the same job using the passed state code to extract data for that state. Can anyone please help me with how to pass the state-code parameter in the SQL stmt where clause for any database stage? [I am trying this on Teradata connector..]

Thank you.
Chandu.

[ArndW]

Have you tried using user-defined SQL and using the #Parameter Name# value in it?

[chulett]

Doesn't need to be 'user defined' to utilize a job parameter.